Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue

Mon, 24 Feb 2003 19:26:38 -0800

Uhm michael, you need to decide where you want to put the jars in the first place, if you want the driver available to all webapps then you put it there. If you just want it for your webapp then you can put it into the lib directory. I'm not sure if it will cause major problems but it's best to put it in one place at one time first.
Also please check your spelling for your driver in the jsp code, you may have mispelled it and caused it to look for something else.




Michael Ni wrote: 

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.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]



_________________________________________________________________
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]

Reply via email to