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]