JBoss Community

Accessing MS SQL 2008 from JBoss 6.1 - Server major version:8 is not supported by this driver.

created by Roger Lee in Datasource Configuration - View the full discussion

I using JBoss AS 6.1.0 Final and running using the JRE 6 included with jdk1.6.0_32.

 

I need to connect to a MS SQL 2008 database and have downloaded the latest Microsoft JDBC drivers contained in sqljdbc_4.0.2206.100_enu.exe.

 

I have copied sqljdbc4.jar to the default\lib folder and configure my DS etc.

 

When my App tries to connect to the MS SQL database I get;

 

12:32:53,064 WARNING [SQLServerConnection] ConnectionID:1 ClientConnectionId: a0955e8d-226a-44e6-b8f8-b0217cd3cf47 Server major version:8 is not supported by this driver.

12:32:53,080 WARN  [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null: org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server version 8 is not supported by this driver. ClientConnectionId:a0955e8d-226a-44e6-b8f8-b0217cd3cf47)

 

A couple of posts said it was due to a bug in a previous JRE and upgrading to 32 woul resolve it.

 

Any ideas?

 

TIA.

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community