JDBC connection not working for MS sql

[Former Member]

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

[bhavesh_kantilal]

The error says - Error Establishing Socket. Can you check if the Firewall ports to the TCP Port of your DB is open? You can do a Telnet command from the PI Server to confirm the same ( or your basis team can ).

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

Thanks for your mail.

we are unable to connect to their host  due to getting the error with  drivers .

Thanks

Madhu

[former_member182412]

Hi Madhu,

Check this sap note to use right driver 1615198 - PI JDBC and JMS Adapter driver's JRE compatibility

according to above note you need to deploy sqldriver4  jar file in your PI server. Did you deploy this jar file??

MSSQL driver	JRE
sqldriver12	1.4
sqldriver	5.0
sqldriver4	6.0

Regards,

Praveen.

[Former Member]

Hi Praveen,

Thanks for your mail.

we are now using same SQLDRIVER4 and along these we are using another sqljabc which is old version. my doubt even though latest drivers in system is it taking older versions?

is system behave like this?

Please confirm.

Thanks

Madhu T