Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 15262 invoked from network); 25 Feb 2003 03:19:43 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 25 Feb 2003 03:19:43 -0000 Received: (qmail 15377 invoked by uid 97); 25 Feb 2003 03:21:24 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 15370 invoked from network); 25 Feb 2003 03:21:23 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 25 Feb 2003 03:21:23 -0000 Received: (qmail 13631 invoked by uid 500); 25 Feb 2003 03:19:26 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 13615 invoked from network); 25 Feb 2003 03:19:26 -0000 Received: from f185.sea1.hotmail.com (HELO hotmail.com) (207.68.163.185) by daedalus.apache.org with SMTP; 25 Feb 2003 03:19:26 -0000 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 24 Feb 2003 19:19:35 -0800 Received: from 128.91.107.144 by sea1fd.sea1.hotmail.msn.com with HTTP; Tue, 25 Feb 2003 03:19:35 GMT X-Originating-IP: [128.91.107.144] From: "Michael Ni" To: tomcat-user@jakarta.apache.org Bcc: Subject: RE: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue Date: Mon, 24 Feb 2003 19:19:35 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 25 Feb 2003 03:19:35.0565 (UTC) FILETIME=[B8E1B3D0:01C2DC7C] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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" >Reply-To: "Tomcat Users List" >To: "Tomcat Users List" >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.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: 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