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

java sql-server-2008 websphere-7
Ravinder picture Ravinder · Oct 4, 2012 · Viewed 15.9k times · Source

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

Jon Skeet picture Jon Skeet · Oct 4, 2012

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

Related questions

List of JDBC drivers for SQL Server 2008 (comparison)

I am in the process of evaluating a whole whack of JDBC drivers, specifically to use with SQL Server 2008 with Windows authentication. I gathered a list of ones that I found and have listed them below. My question is, are …

Read More
Java7 sqljdbc4 - SQL error 08S01 on getConnection()

I'm trying to write a really simple GUI app for inserting some records into a database, and reading back some records (nothing fancy, just 1 table with 3 rows, no relations). The source... package EntryProg; import java.sql.*; import com.microsoft.sqlserver.…

Read More
How to pass Table-Valued parameters from java to sql server stored procedure?

I have a Student class with the following attributes: Name, Department, Address, Grade. Now I have an ArrayList that contains some Student objects like this, List<Student> stuList = new ArrayList<Student>(); stuList.add(new Student("Tom","…

Read More