Put msutil.jar, mssqlserver.jar, and msbase.jar in WEB-INF/lib and all will be happy.
----- Original Message ----- From: "Michael Ni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 9:32 PM Subject: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > 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.SQL ServerDriver > 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]
