[jboss-user] [Datasource Configuration] - Accessing MS SQL 2008 from JBoss 6.1 - Server major version:8 is not supported by this driver.

[Roger Lee]

Roger Lee [https://community.jboss.org/people/NOTiFY] created the discussion

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

To view the discussion, visit: https://community.jboss.org/message/735357#735357

--------------------------------------------------------------
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
[https://community.jboss.org/message/735357#735357]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20120514/ea880f44/attachment.html