JDBC receiver channel problem

[Former Member]

Hi..

I am doing File to JDBC scenario, for that i am using MicrosoftSqlServer.

Driver----com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection------jdbc:microsoft:sqlserver://172.18.133.91:1433;DatabaseName=LMS

While executing, in the JDBC receiver channel it is showing the below error.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://172.18.133.91:1433;DatabaseName=LMS': ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

Could please tell where will be the problem.

Thanks in advance,

Leela

[Former Member · Accepted solution]

did u installed JDBC Driver?

check IP in ipconfig command in Command Prompt.

[Former Member]

Hi ,

Driver shoud be :

com.microsoft.sqlserver.jdbc.SQLSeverDriver

Connection:

jdbd:microsoft:sqlserver://<ip address>:port;databaseName=TNS

try with above config..make sure that they are case sensitive.

Regards,

Sreenivas.

[Former Member]

check

1) Conncection between XI and database

2) JDBC parameters in adapter.

Cannot establish connection to URL i think because it is not able to connect to database.

chirag