Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org Received: (qmail 20443 invoked from network); 25 Feb 2003 03:27:03 -0000 Received: from exchange.sun.com (192.18.33.10) by daedalus.apache.org with SMTP; 25 Feb 2003 03:27:03 -0000 Received: (qmail 15456 invoked by uid 97); 25 Feb 2003 03:28:47 -0000 Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org Received: (qmail 15449 invoked from network); 25 Feb 2003 03:28:47 -0000 Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12) by nagoya.betaversion.org with SMTP; 25 Feb 2003 03:28:47 -0000 Received: (qmail 19034 invoked by uid 500); 25 Feb 2003 03:26:50 -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 19023 invoked from network); 25 Feb 2003 03:26:50 -0000 Received: from albatross.mail.pas.earthlink.net (207.217.120.120) by daedalus.apache.org with SMTP; 25 Feb 2003 03:26:50 -0000 Received: from user-119a4ld.biz.mindspring.com ([66.149.18.173] helo=lucy.hunterweb.net) by albatross.mail.pas.earthlink.net with esmtp (Exim 3.33 #1) id 18nVkB-0003aA-00 for tomcat-user@jakarta.apache.org; Mon, 24 Feb 2003 19:26:59 -0800 Received: from 4SFHR01 (laptop.hunterweb.net [192.168.254.19]) by lucy.hunterweb.net (8.12.3/8.12.3/SuSE Linux 0.6) with SMTP id h1P3QwEO008006 for ; Mon, 24 Feb 2003 22:26:58 -0500 Message-ID: <011701c2dc7d$bf693100$13fea8c0@divine.com> From: "Ian Hunter" To: "Tomcat Users List" References: Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue Date: Mon, 24 Feb 2003 22:26:55 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Mine works fine. The only place I have the ms*.jar files on my system is webapps\\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" To: 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" > >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.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