Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Different sqljdbc Driver(Require to use a different sqljdbc driver after database migration)
Different sqljdbc Driver [message #1462281] Wed, 05 November 2014 12:09 Go to next message
Alan Farroll is currently offline Alan FarrollFriend
Messages: 60
Registered: June 2012
Member
Hi,

A Java servlet I maintain connects to a SQL server database that was migrated to a new server recently. The database previously run on Sql Server 2005 SP2 but now runs on SQL Server 2008 R2 SP2 and the connection has stopped working. My investigation seems to point to using the driver sqljdbc4-3.0.jar instead of sqljdbc1-2.0.jar. I have plaved the sqljdbc4.3.0.jar in the tomcat \lib directory but still doesn't work. I have also added to the "Windows" classpath environment variable the value %CATALINA_HOME%\lib\sqljdbc4-3.0.jar but again still does not work.

How do I make the servlet use the new driver?

Thanks in advance

AJF
Re: Different sqljdbc Driver [message #1463910 is a reply to message #1462281] Fri, 07 November 2014 02:22 Go to previous messageGo to next message
Russell Bateman is currently offline Russell BatemanFriend
Messages: 3798
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

On 11/05/2014 05:09 AM, Alan Farroll wrote:
> Hi,
>
> A Java servlet I maintain connects to a SQL server database that was
> migrated to a new server recently. The database previously run on Sql
> Server 2005 SP2 but now runs on SQL Server 2008 R2 SP2 and the
> connection has stopped working. My investigation seems to point to
> using the driver sqljdbc4-3.0.jar instead of sqljdbc1-2.0.jar. I have
> plaved the sqljdbc4.3.0.jar in the tomcat \lib directory but still
> doesn't work. I have also added to the "Windows" classpath environment
> variable the value %CATALINA_HOME%\lib\sqljdbc4-3.0.jar but again still
> does not work.
>
> How do I make the servlet use the new driver?
>
> Thanks in advance
>
> AJF

I would suggest posting in the Eclipse DTP forum.
Re: Different sqljdbc Driver [message #1467867 is a reply to message #1463910] Mon, 10 November 2014 11:20 Go to previous message
Alan Farroll is currently offline Alan FarrollFriend
Messages: 60
Registered: June 2012
Member
Thanks Russell. Will do.
Previous Topic:Eclipse unable to clean build output
Next Topic:Jogek.ER - Malware or false-positive
Goto Forum:
  


Current Time: Tue Sep 29 20:24:54 GMT 2020

Powered by FUDForum. Page generated in 0.03294 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top