JDBC connection not working for MS sql
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.