Skip to Content

JDBC Adapter in Error

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Sep 01, 2006 at 02:39 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2006 at 04:49 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 01, 2006 at 04:50 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.