I am trying to implement the File to JDBC scenario.
I want to save file data into database table.
My file sender is working fine.
My XML message is also passing the XI Pipeline without any error.
But at the receiver end the JDBC Adapter is in error.
XI is not able to establish connection.
The error description is as follows:
Receiver Adapter v2808 for Party '', Service 'TRY_BS_JDBC_RECEIVER':
Configured at 2006-09-01 07:30:37 UTC
- 2006-09-01 13:43:43 UTC: Error: Accessing database connection '<b>jdbc:microsoft:sqlserver://172.17.35.64
INFVA02093:1433;DatabaseName=XI_JDBC</b>' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://172.17.35.64
INFVA02093:1433;DatabaseName=XI_JDBC': SAPClassNotFoundException: <b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>
Here, <b>XI_JDBC</b> is my database name.
<b>//172.17.35.64</b> is the server on which my database is running.
INFVA02093</b> is the instance name.
I have following question:
1. How do I check whether MS SQL Server Driver is installed on the Integration Server?
2. Is there any other way I can check whether the connection to MS SQL Server mentioned above is working fine or not?
Looking forward for some replies soon.