SQLEr.ResourceException

[nikhil_bose]

I have deployed [MS-SQL jdbc 2.0|http://www.google.co.in/url?sa=t&source=web&ct=res&cd=1&url=http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Fdata%2Faa937724.aspx&ei=tvFSStj7NpPq6AOslOXJBw&usg=AFQjCNHRgg02jfuW0RdXraaQlMZAESLlUw&sig2=0xgTb5ZPGL_wpVxNdwAZuQ] driver.

But the data source up on the same driver shows an exception on a simple select query.

SQLEr.ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later

Environment:

NetWeaver: NW 7.1 SR 5

SQL Server: MS-SQL 2008

Driver: JDBC 2.0 (supports SQL 2003, SQL 2005, SQL 2008)

JEE: 1.5

Please help me to resolve this issue.

Nikhil

[Former Member · Accepted solution]

Hi,

Check the below thread

Regards,

Saleem

[nikhil_bose]

Deployed sqljdbc.jar file ; dont deploy sqljdbc4.jar

[nikhil_bose]

Now I am getting another exception!!!!!

SQLEr.ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out

Max. Time to wait for Connection: 6000 sec

Connection Lifetime: 6000 sec.

Clean up Interval: 5000 sec.

I have network delay to reach JEE server of 400 msec

Any idea?

[Former Member]

Hi,

Check this below thread and the correct driver you are using.

Regards,

Charan