Hi.
For first. I have no knowledge in the JDBC adapter so if you have any answers please have in mind to keep it on a basic lvl.
I colleague of mine migrated a solution we have with the JDBC adapter from XI 3.0 to PI 7.1.
In XI 3.0 the solution worked fine but in PI 7.1 we get the following error.
Error during database connection to the database URL 'jdbc:microsoft:sqlserver://<HOST>:<PORT>;DatabaseName=<DB>'
using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException:
Can not establish connection:: SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.'
What can the problem be?
BR
Kalle