jdbc receiver diffrent sql versions

[Former Member]

hello

we are using 2 types of sql 2000 & 2005

do you know if the 2005 jdbc driver only is compatible for version 2000 also?

thx and regards

shai

[dharamveer_gaur2 · Accepted solution]

check this thread

msbase.jar, mssqlserver.jar, msutil.jar for SQL server 2000

sqljdbc.jar for SQL server 2005

[Former Member]

Hi,

For MS SQL Server 200 use the following drivers,

msbase.jar,

mssqlserver.jar,

msutil.jar

And for MS SQL Server 2005 use the following drivers,

sqljdbc.jar

Urs,

Soorya

[Former Member]

Hi

check

link

http://msdn.microsoft.com/en-us/data/aa937724.aspx

Download the SQL Server 2005 JDBC Driver 1.0

This earlier version of the JDBC driver can be used to connect to SQL Server 2000 or SQL Server 2005 databases. This version of the JDBC driver is available in Simplified Chinese, Traditional Chinese, German, English, Spanish, French, Italian, Japanese, Korean, and Swedish.

deploy latest version wud work for both

rgds

srini

[Former Member]

Hi,

The drivers for sql 2000 & 2005 might be different.

But if you are using 2000 and want to upgrade it to 2005 then you need use different format of the URL and driver name like,

If you are using SQL Server 2005 driver, then class name should

be as follows:

Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

URL :jdbc:sqlserver://<db_Server>:port;databaseName=<db_name>

If you are using SQL Server 2000 driver , then class name should

be as follows:

Driver class: com.microsoft.jdbc.sqlserver.SQLServerDriver

and URL is as follows:

jdbc:microsoft:sqlserver://<db_server>:port;databaseName=<

db_name>

Check this once and try to run scenario.

Urs,

Soorya