Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue

[Tim Funk]

Tomcat ignores your CLASSPATH variable. For more information about 
tomcat handles classloaders, see here:

http://jakarta.apache.org/tomcat/tomcat-4.1-doc/class-loader-howto.html

-Tim

Michael Ni wrote:
My goal is to use JSP to query from my Microsoft SQL Server 2000.

I have successfully created my environments and installed the drivers 
for the Microsoft SQL Server 2000 JDBC.

However when i run my script i get the following error

Driver not found:java.lang.ClassNotFoundException: 
com.microsoft.jdbc.sqlserver.SQLServerDrivercom.microsoft.jdbc.sqlserver.SQLServerDriver 

exception: java.sql.SQLException: No suitable driverNo suitable driver

you can see for yourself at the following url

http://128.91.107.144:8080/test/home.jsp

I attached my home.jsp page.  Does tomcat need to have the microsoft 
drivers physically in the folder or subfolders of c:\Tomcat 4.1?  All i 
did was create the CLASSPATH which assigned CLASSPATH to the 3 jar 
driver files.  I've been stuck on this issue for 3 days.  Can anyone 
help me?





_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.  
http://join.msn.com/?page=features/virus

------------------------------------------------------------------------

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]