java.sql.SQLException: SQL Server version 8 is not

Question

I have upgraded my application to Websphere 7.0from Websphere 6.1. I am using Microsoft SQL server jdbc driver 4.0 for this application. When i use sqljdbc4.jar i get the following error when connecting to database for authentication.

  SystemError java.sql.SQLException: SQL Server version 8 is not supported by this driver. SQL State = 08S01, Error Code = 0

How to get rid of this.

Answer 1

Yes, as per the Microsoft SQL Server JDBC type 4.0 driver system requirements page:

The JDBC driver supports connections to a SQL Azure Database and SQL Server 2005 and later.

It sounds like you're running SQL Server 2000.

Either change driver (e.g. to jTDS) or upgrade to a more recent release of SQL Server (which would presumably be a rather bigger task...)

Answer 2

You not need change your driver, only your url connection. Try this:

String url = "jdbc:sqlserver://"+SERVER+":"+PORT+";databaseName="+DATABASE+ ";user=" +USER+ ";password=" +PASS+ ";";

change for

String url ="jdbc:jtds:sqlserver://"+SERVER+":"+PORT+";databaseName="+DATABASE+ ";user=" +USER+ ";password=" +PASS+ ";";