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" <[EMAIL PROTECTED]>
Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> >> Reply-To: "Tomcat Users List" <[EMAIL PROTECTED]>
> >> To: "Tomcat Users List" <[EMAIL PROTECTED]>
> >> 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:[EMAIL PROTECTED]
> >> Sent: Tuesday, February 25, 2003 10:32 AM
> >> To: [EMAIL PROTECTED]
> >> 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: [EMAIL PROTECTED]
> >> For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> > _________________________________________________________________
> > MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> > http://join.msn.com/?page=features/virus
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail



--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]





--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]



Reply via email to