Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 22997 invoked from network); 25 Feb 2003 03:27:29 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 25 Feb 2003 03:27:29 -0000 Received: (qmail 15469 invoked by uid 97); 25 Feb 2003 03:29:13 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 15462 invoked from network); 25 Feb 2003 03:29:13 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 25 Feb 2003 03:29:13 -0000 Received: (qmail 19210 invoked by uid 500); 25 Feb 2003 03:26:51 -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 19021 invoked from network); 25 Feb 2003 03:26:49 -0000 Received: from unknown (HELO mymail) (219.94.76.124) by daedalus.apache.org with SMTP; 25 Feb 2003 03:26:49 -0000 Received: from makmal.net ([219.94.76.122]) by mymail (8.11.6/8.11.6) with ESMTP id h1P3NLV26969 for ; Tue, 25 Feb 2003 11:23:22 +0800 Message-ID: <3E5AE37B.2050201@makmal.net> Date: Tue, 25 Feb 2003 11:31:07 +0800 From: Peng Tuck Kwok User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3a) Gecko/20021212 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tomcat Users List Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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" >> 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org