Friday, February 10, 2006 05:43 PM
If you setup a DSN, you can only use ODBC to connect. No special driver needed. However, if you decide to use the MySQL driver, you don't need a DSN. The JAR is usually placed in the classpath of your appserver. Generally in the form of common/lib or something similar... Check your appserver docs for that path.
Friday, February 10, 2006 05:08 PM
Besides the jar-problems, if you create a DSN, you can just use ODBC instead of the actual driver. If you use the driver, the jar should be in the classpath of the applicationserver. Generally, it would be in some sort of common/lib directory...