tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ian Hunter" <ihun...@hunterweb.net>
Subject Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Date Tue, 25 Feb 2003 03:26:55 GMT
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" <mikeni123@hotmail.com>
To: <tomcat-user@jakarta.apache.org>
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" <galbayar@mobinet.mn>
> >Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> >To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
> >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:mikeni123@hotmail.com]
> >Sent: Tuesday, February 25, 2003 10:32 AM
> >To: tomcat-user@jakarta.apache.org
> >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: tomcat-user-unsubscribe@jakarta.apache.org
> >For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message