on 09-01-2006 3:32 PM
Hi,
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
History:
- 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.
<b>
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.
Regards,
Vijay Mahawar.
Hi,
>>>>. How do I check whether MS SQL Server Driver is installed on the Integration Server?
did you deploy the driver ?
it's not deployed in standard
so if you don't see any jdbc channel
that makes use of MS SQL server then it's probably not deployed
Regards,
michal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Look into this-guide
Also go thru this thread once-
Regards,
Moorthy
Vijay:
One way to verify whether you have deployed the
JDBC drivers or not IS:
look into Drive:\usr\sap\SID\DVEBMGS##\j2ee\cluster\
server0\bin\ext to see if the files are there.
Please give points if helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vijay:
One way to verify whether you have deployed the
JDBC drivers or not IS:
look into Drive:\usr\sap\SID\DVEBMGS##\j2ee\cluster\
server0\bin\ext to see if the files are there.
Please give points if helpful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.