JDBC Receiver Adapter and JDBC Drivers
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:
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.