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.