SQL Server version 8 is not supported by this driver

[former_member203984]

Hi All,

I am trying to connect one of the sql server of 2000 version. I tried using both sqljdbc.jar and sqljdbc4.jar, but I am not able to connect.

When I see the logs it showing as "SQL Server version 8 is not supported by this driver".

I am using

JDBC driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

server URL: jdbc:sqlserver://SUDDWSQLCL01;database=DWP01.

Please let me know which .jar file is the correct to be used.

Regards

G.Partheeban

[Nikhil_Makhija · Accepted solution]

Hi,

Either change driver (e.g. to jTDS) or upgrade to a more recent release of SQL Server.

[former_member203984 · Accepted solution]

Hi nikhil

I saw this post In google. But can you please explain the procedure for jtds.

also tell me what to mention in server URL and JDBC driver?

regards

G.Partheeban

[Nikhil_Makhija · Accepted solution]

As per Micrsoft site they dont provide driver support for SQL server 2000 , as an alternative I can see this drivers to upload and give it a try ..if it works..

Check the below link for more details :

jTDS JDBC Driver

[former_member203984 · Accepted solution]

HI nikhil

I already tried with the jTDS 1.2 driver but no luck.

can you tell me the JDBC driver and server URL details To be entered?

Regards

G.Partheeban

[former_member203984 · Accepted solution]

Hi Guys,

Got the solution. It works fine with jTDS.

Used jtds-1.2.1.jar file and

JDBC driver : net.sourceforge.jtds.jdbc.Driver

Server URL : jdbc:jtds:sqlserver://SUDDWSQLCL01/LIMSDM

Thanks for the replies.

Regards

G.Partheeban

[Former Member]

Helllo Partheeban,

This could be because you may be using Driver 4.0 with SQL 2000.

According to Microsoft's website, JDBC Driver 4.0 driver supports connections  to SQL Server 2005 and above.

  Try downloading Driver 3.0.

http://www.microsoft.com/en-in/download/details.aspx?id=21599 .

Choose to download the one with .tar.gz as extension. Extract it. you can try with sqljdbc.jar. It should work out.

Make sure to delete & deploy the already present driver before uploading the new one.

Regards

Tufale Ashai

[former_member203984]

HI Tufale,

As I said I already tried with both the JDBC drivers also the individual sqljdbc.jar and sqljdbc4.jar. No luck it throws the same error.

Is that any problem in the

JDBC driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

server URL: jdbc:sqlserver://SUDDWSQLCL01;database=DWP01.

Please let me know.

Regards

G.Partheeban

[former_member203984]

Hi ,

Can any one please help me getting the solution for the above?

Tried with both JDBC 2.0 and 3.0 but no luck.

Regards

G.Partheeban