ODBC vs. JDBC on MS SQL 2000

[Former Member]

Hello,

This is an issue we dont understand.

We would like to connect to a MS SQL 2000 DB via JDBC adapter.

The support guy for thsi DB told us

"The drivers you need to install are ODBC". ????

Now we installed a JDBC driver from microsoft page but this is the error we get when trying to connect.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://10.60.104.99;Database=Buysite_EB02': UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver (Unsupported major.minor version 49.0)

So it seems that the driver for MS SQL 2000 installed is not the right one?

But what about the ODBC advice. Is this something important?

So it is not the SQL that is important but the fact that we need to use a ODBC driver.

But how to find that and how will the Connection parameter look like?

Sorry to ask silly questions. But we don t really understand this issue.

Best regards

Dirk

[former_member181962]

Check this sap note: Note 639702

[Former Member]

Note 639702 seems not to be the right solution:

This is an excerpt from the FAQ OSS Note 831162

13. JDBC Drivers

o Q: I downloaded JDBC driver for MS SQL server from Service market

place according to Note 639702. Can I use this driver for JDBC

Adapter?

o A: No. This driver can only be used from OpenSQL which is a SAP own

database access layer for Java. This driver should not be used with

XI JDBC adapter. Customers should download official JDBC driver

given by Microsoft web site

Regards

Dirk

[Former Member]

It seems the configuration driver details you have used are not correct

Please make sure you are using the below driver details,

com.microsoft.sqlserver.jdbc.SQLServerDriver

Thanks

Ramg

Edited by: Ramkumar Ganesh on May 6, 2010 5:48 PM