tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peng Tuck Kwok <pengt...@makmal.net>
Subject Re: Tomcat and Microsoft SQL Server 2000 JDBC Driver issue
Date Tue, 25 Feb 2003 03:57:15 GMT
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


Mime
View raw message