JDBC connection error: Version not supported

[former_member296836]

Dear all,

our system:

PI 7.11 Level 0004

Java: 5.1.027

SQL-Version:

SQLSERVER 2008

JDBC is sqljdbc.jar deployed.

While trying to connect to the server we receiving following error:

Error during database connection to the database URL 'jdbc:sqlserver://serverxy:1433;databaseName=NameOfDB' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later.'

But AFAIK the sqljdbc.jar should fit to this version, shouldn't it?

Any ideas what could be wrong?

Regards

Chris

[former_member463616]

Hi,

>>>>How can I determine which version is installed, if the name is the same for different SQL versions?

For the above querie, please ask your SQL Team.

It seems to problem with JRE Version. So, please update your JRE version and then install the SQL server 2008 driver. I hope that the below link is might be useful to you.

/people/dheeraj.kumar5/blog/2010/03/23/sql-server-2008-connectivity-with-sap-pi-70-possile

Regards,

Rajesh

[former_member296836]

Thanks for reply, but I would like to know how to determine

which version my sqljdbc.jar version is.

From chriag's SAP note I figured out that we could have 1.2 or

2.0 as version. I think, we have deployed 1.2. that could not be used

for SQL 2008, but I am not sure that this is really version 1.2 installed now.

[former_member463616]

Hi,

>>>>>>>The server version is not supported. The target server must be SQL Server 2000 or later.'

You have to use Microsoft SQL Server JDBC driver v1.2 that supports connecting to SQL Server 2008. Install this driver on XI server

I hope that, the below link might be useful to you.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115156

Regards,

Rajesh

Edited by: Rajesh_1113 on Feb 16, 2011 3:38 PM

[former_member296836]

Hi,

is it possible that the sqljdbc.jar exist in different version and I installed a version

that supports SQL Server only until version 2005???

How can I determine which version is installed, if the name is the same for different SQL versions?

And is a newer version of sqljdbc.jar is compatible with old SQL server versions?

thanks

Chris

[Former Member]

Look at this sap note:- 639702 and other relevant note as well -831162/1138877

chirag