5

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.

thar45
  • 3,518
  • 4
  • 31
  • 48
Ravinder
  • 78
  • 1
  • 1
  • 6

2 Answers2

7

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...)

Jon Skeet
  • 1,421,763
  • 867
  • 9,128
  • 9,194
  • I have the same issue even though the server version is "9.0.5292" aka 2005. The connection to my local 2005 server works, but not to a remote machine named "DEVDB1\SQL2005". – Daniil Shevelev Jul 10 '13 at 13:19
  • @DaSh: The *exact* same issue? If you're really getting an error message of "SQL Server version 8 is not supported [...]" then that doesn't sound like you're talking to a SQL Server 2005 machine... – Jon Skeet Jul 10 '13 at 13:24
  • I am 100% sure the instance is 2005. Could other software, such as OS, have an affect on what JDBC sees/recognizes? – Daniil Shevelev Jul 10 '13 at 13:55
  • Actually, I was connecting to wrong instance (wrong port). Thank you Jon. – Daniil Shevelev Jul 10 '13 at 14:16
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+ ";";
dsandrade
  • 576
  • 5
  • 9