Skip to main content



      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 07:09 Go to next message
Eclipse UserFriend
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] Thu, 06 November 2014 21:22 Go to previous messageGo to next message
Eclipse UserFriend
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 06:20 Go to previous message
Eclipse UserFriend
Thanks Russell. Will do.
Previous Topic:Eclipse unable to clean build output
Next Topic:Jogek.ER - Malware or false-positive
Goto Forum:
  


Current Time: Mon Jul 07 22:36:00 EDT 2025

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

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

Back to the top