JDBC Receiver Adapter and JDBC Drivers

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

The error saying it is unable to connect to the Database, so it may be the drivers problem. once check the drivers and its syntaxes.

Syntax :

http://www.devx.com/tips/tip/28818

For Download and configure the drivers :

http://www.aquafold.com/docs-jdbcdrivers-oracle10g.html

http://www.oxygenxml.com/database_drivers.html

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

[Former Member · Accepted solution]

Thank you for the posting. We have the drivers. But the connection does not work.

Please help.

Thank you.

[VijayKonam · Accepted solution]

It must be drivers problems. They might have not got installed properly.

VJ

[Former Member · Accepted solution]

VJ,

Could you specify how to check the installation?

Thank you.

[VijayKonam · Accepted solution]

Your basis people must help you in this. Ask them while deploying the SDA, whether they got a success information or not.. ask them to re-do it for u.

VJ

[Former Member · Accepted solution]

Hi,

We faced similar problem. But when we tried connecting from a java program we were not able to. Then we found that the port was not opened. So check that.

Thanks

Shakthi

[Former Member · Accepted solution]

Hi Shakthi,

The port is open. I found out by running the telnet utility (telnet hostname port). It did not give any error. Do you think it still could be the port?

Thank you.

[Former Member · Accepted solution]

Got it resolved by installing the JDBC drivers from Microsoft site. We had the ones from SAP before!

Thank you all.

[Former Member]

Hi.

This guide will help you :https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d88f

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bdd6a690-0201-0010-238a-9c95a5fb...

thanks

farooq