Skip to Content

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

JDBC Receiver Adapter and JDBC Drivers

Dear Experts,

We are trying to implement the interface R/3 to PI 7.0 to SQL Server 2005. The JDBC Drivers were installed by the BASIS team. We get the folloing errors:

Message Monitor:

com.sap.aii.af.ra.ms.api.DeliveryException: Database connection could not be established

Communication channel moniotor:

Error during database connection to the database URL 'jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;databaseName=xxxxxxxx' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;databaseName=xxxxxxxx': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

We also tried using the host name for the sql server box instead of the i/p address in the jdbc receiver channel.

We tested the connection to the database from a pc trhu ODBC (Windows control panel) and also by using telnet.

I could not find a how to guide for this (PI 7.0). Is there any additional setting required in XI? How do we check if the jdbc drivers are installed ok?

Could you please help?

Thanks a lot.

Helpful Answer

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