Eclipse Community Forums: Newcomers » Different sqljdbc Driver

Home » Newcomers » Newcomers » Different sqljdbc Driver(Require to use a different sqljdbc driver after database migration)

Show: Today's Messages :: Show Polls :: Message Navigator

Different sqljdbc Driver [message #1462281]

Wed, 05 November 2014 12:09

Alan Farroll

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

Report message to a moderator

Re: Different sqljdbc Driver [message #1463910 is a reply to message #1462281]

Fri, 07 November 2014 02:22

Russell Bateman

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.

Report message to a moderator