JDBC Adapter Error to conect to SQL Server 2005

[Former Member]

Hi all.

I´m trying to conect to a SQL Server 2005 database, but facing this error:

UnsupportedClassVersionError: (com/microsoft/sqlserver/jdbc/SQLServerDriver) bad major version at offset=6'

The parameters are:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://

How can I resolve this issue?

Thanks.

[Former Member · Accepted solution]

your connect string seems to be wrong. try this one:

jdbc:microsoft:sqlserver://192.2.1.3:1433;databaseName=MYDB

[Former Member · Accepted solution]

Hello.

My problem was solved using the driver JTDS.

JDBC Driver: net.sourceforge.jtds.jdbc.Driver

Connection jdbc:jtds:sqlserver://<db_host>:<db_port>;databaseName=<db_name>

The 1.2 version of Microsoft driver was discontinued.

Thanks.

[Former Member]

The jdbc driver seems to be incompatible. Use the compatible version from [http://www.microsoft.com/downloads/details.aspx?familyid=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en|http://www.microsoft.com/downloads/details.aspx?familyid=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en]

[Former Member]

I made the download of the driver, added to the aii_af_jmsproviderlib.sda file and redeployed it, but the problem persists.

Any other idea?

Thanks.