Mine works fine. The only place I have the ms*.jar files on my system is webapps\<appname>\WEB-INF\lib -- I have a Win2K Dell laptop running jdk1.4.0 and Tomcat 4.1.18, connecting to SQL2K through a firewall -- the same box running SQL2K also hosts a duplicate application, and I've even had a Sun SPARCserver 20 running SuSE Linux 7.3, blackdown jdk1.3.1 and tomcat 4.1.12 connecting to the SQL server just fine.
Maybe delete your C:\Tomcat 4.1\work\* directories to force Tomcat to recompile your JSPs. I've had it go squirrelly on me in the past when making lots of changes. I can't imagine why you're having this problem. ----- Original Message ----- From: "Michael Ni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 24, 2003 10:19 PM Subject: RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > > ive copied to my > C:\Tomcat 4.1\webapps\ROOT\WEB-INF\lib > C:\Tomcat 4.1\common\lib > and it still doesn't work. > > has anyone actually got their scripts to query from SQL Server 2000 using > the Microsoft SQL Server 2000 JDBC Driver? seems like sun products never > work with microsofts > > michael ni > > > > >From: "Galbayar Dorjgotov" <[EMAIL PROTECTED]> > >Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]> > >To: "Tomcat Users List" <[EMAIL PROTECTED]> > >Subject: RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue > >Date: Tue, 25 Feb 2003 11:15:44 +0800 > > > >copy common\lib directory > > > >-----Original Message----- > >From: Michael Ni [mailto:[EMAIL PROTECTED] > >Sent: Tuesday, February 25, 2003 10:32 AM > >To: [EMAIL PROTECTED] > >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.SQ L > >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] > > > _________________________________________________________________ > 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]