cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Adapter in Error

vijaymahawar
Discoverer
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

MichalKrawczyk
Active Contributor
0 Kudos

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

vijaymahawar
Discoverer
0 Kudos

<b>"if you don't see any jdbc channel"</b>

Where do I have to check for the JDBC Channel?

Please also let me know about other ways of testing my connection? So that I can make sure that my connection is working fine and there is no problem with my connection string.

With Regards,

Vijay Mahawar.

moorthy
Active Contributor
0 Kudos

HI,

Look into this-guide

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Also go thru this thread once-

Regards,

Moorthy

Answers (2)

Answers (2)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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.