Connect to SQL 2000 and 2012

[Former Member]

We have two interfaces. Once connects to 2000 and the other to 2012. Which JDBC drivers do I need to deploy. is it both sqljdbc.jar and sqljdbc4.jar?

Pls advice.

Thanks

[Former Member · Accepted solution]

Resolved.

Used sqljdbc4.jar for SQL servers 2005 onwards.

Though microsoft says JDBC driver 3.0 supports connection with 2000, we were getting errors.

As an alternative we used mssqlserver.jar, msbase.jar and msutils.jar to connect to SQL server 2000 and it works fine.

So we have more than one driver installed on pur PI system.

Thanks.

[udo_martens]

Hi,

this is actually not PI related. You will find this information in the documentation of the DB provider.

/Udo