Verifying your CLASSPATH setting
Any time something does not work and you are certain it isn't due
to the code in your JSP page, check the CLASSPATH for your machine.
It's the source of most problems in JSP development, in my experience.
For the Tomcat web server to successfully make a connection to
an ODBC-compliant database, it must be able to access the Java classes
that provide the JDBC-ODBC bridge. These classes are contained in
<Java SDK installation directory>\jre\bin
For Tomcat to be able to access the classes, this directory must
be included in your CLASSPATH setting.
In Windows 95/98/ME, your CLASSPATH setting is made in the autoexec.bat
Open your autoexec.bat
file, and find the entry that starts with SET
Make sure that it includes the directory <Java
SDK installation directory>\jre\bin.
Save and close your autoexec.bat
- Reboot your machine.
If you are not running Windows 95/98/ME, please indicate what operating
system you are using, and provide your email address, and I will
try to find out where the CLASSPATH settings are stored in your
particular operating system.