Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC connection not working for MS sql

Hi Team,

Hope all are doing well.

currently we are working on SAP PO 7.4 single stack.

we are using JDK version 16 and installed MS SQL 2000.

when we tried to send message to database we are getting below error.

Transmitting the message to endpoint <local> using connection IDoc_AAE_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.microsoft.jdbc.sqlserver.SQLServerDriver returns: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket..

: SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing sock



same drivers we used in SAP PI 7.11 and there we used JDK 13 and there we are able to send the message to same database successfully.


but in 7.4 we are getting error as above.


can you please check and guide me to fix the issue asap.


Thanks

Madhu T

Former Member
Not what you were looking for? View more on this topic or Ask a question