Eclipse Community Forums: Newcomers » Different sqljdbc Driver

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

Eclipse User

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

Eclipse User

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

Eclipse User

Thanks Russell. Will do.

Previous Topic:	Eclipse unable to clean build output
Next Topic:	Jogek.ER - Malware or false-positive

Goto Forum:

-=] Back to Top [=-

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

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter