Return-Path: 
 <tomcat-user-return-54819-qmlist-jakarta-archive-tomcat-user=nagoya.apache.org@jakarta.apache.org>
Delivered-To: apmail-jakarta-tomcat-user-archive@apache.org
Received: (qmail 74853 invoked from network); 25 Feb 2003 04:00:30 -0000
Received: from exchange.sun.com (192.18.33.10)
  by daedalus.apache.org with SMTP; 25 Feb 2003 04:00:30 -0000
Received: (qmail 16520 invoked by uid 97); 25 Feb 2003 04:02:14 -0000
Delivered-To: qmlist-jakarta-archive-tomcat-user@nagoya.betaversion.org
Received: (qmail 16513 invoked from network); 25 Feb 2003 04:02:14 -0000
Received: from daedalus.apache.org (HELO apache.org) (208.185.179.12)
  by nagoya.betaversion.org with SMTP; 25 Feb 2003 04:02:14 -0000
Received: (qmail 73425 invoked by uid 500); 25 Feb 2003 04:00:12 -0000
Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
List-Subscribe: <mailto:tomcat-user-subscribe@jakarta.apache.org>
List-Help: <mailto:tomcat-user-help@jakarta.apache.org>
List-Post: <mailto:tomcat-user@jakarta.apache.org>
List-Id: "Tomcat Users List" <tomcat-user.jakarta.apache.org>
Reply-To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
Delivered-To: mailing list tomcat-user@jakarta.apache.org
Received: (qmail 73414 invoked from network); 25 Feb 2003 04:00:12 -0000
Received: from f51.sea1.hotmail.com (HELO hotmail.com) (207.68.163.51)
  by daedalus.apache.org with SMTP; 25 Feb 2003 04:00:12 -0000
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	 Mon, 24 Feb 2003 20:00:22 -0800
Received: from 128.91.107.144 by sea1fd.sea1.hotmail.msn.com with HTTP;
	Tue, 25 Feb 2003 04:00:22 GMT
X-Originating-IP: [128.91.107.144]
From: "Michael Ni" <mikeni123@hotmail.com>
To: tomcat-user@jakarta.apache.org
Bcc: 
Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Date: Mon, 24 Feb 2003 20:00:22 -0800
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F51AgJx1V4L0bglUS7Q00028bc3@hotmail.com>
X-OriginalArrivalTime: 25 Feb 2003 04:00:22.0386 (UTC)
 FILETIME=[6B4CF520:01C2DC82]
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Exact problem is tomcat can't read from the CLASSPATH and needs the actual 
files inside the web-inf folder.  So basically to get a connection you need 
to
1 install the sdk
2 install tomcat
3 get all the environmental variables correct
4 install the driver
5 (this is my problem) place a copy of the driver inside the web-inf folder

finally you can have your jsp pages find the driver and then query the 
database.

mike
learned a lot in the past few days






>From: Peng Tuck Kwok <pengtuck@makmal.net>
>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:57:15 +0800
>
>Ok, good to hear you got it to work but I'm curious, what was exact cause 
>of the problem ?
>
>Michael Ni wrote:
>>Thank you Ian Hunter and the rest of the tomcat crew!!!
>>
>>Just got it to work!!!  I'm a grateful student from University of 
>>Pennsylvania trying to make a web application but new to java.  I'm 
>>spoiled by asp and IIS but I figure its time to move on to more powerful 
>>software.  Thanks Everyone you guys are awesome.
>>
>>Mike Ni
>>
>>
>>
>>
>>
>>
>>>From: "Ian Hunter" <ihunter@hunterweb.net>
>>>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: Mon, 24 Feb 2003 22:29:35 -0500
>>>
>>>One reason to use WEB-INF\lib is if you plan on distributing your app or
>>>deploying it to a different system, it's easier to move \webapps\<app>\*
>>>than to worry about lots of little jars in common...
>>>
>>>----- Original Message -----
>>>From: "Peng Tuck Kwok" <pengtuck@makmal.net>
>>>To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>
>>>Sent: Monday, February 24, 2003 10:31 PM
>>>Subject: Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
>>>
>>>
>>> > 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" <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.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
>>> >
>>>
>>>
>>>---------------------------------------------------------------------
>>>To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>>>For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>>
>>_________________________________________________________________
>>STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
>>http://join.msn.com/?page=features/junkmail
>>
>>
>>---------------------------------------------------------------------
>>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


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail


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