Skip to Content
0
Former Member
May 19, 2010 at 06:22 AM

Error when connecting to MSSQL server using JDBC driver

24 Views

Hi

Our Scenario is IDOC to JDBC:

The Data for SAP to PI is through.

for the JDBC connection we have downloaded driver(version1.2) from the

following

link

http://www.microsoft.com/downloads/details.aspx?familyid=C47053EB-3B64-

4794-950D-81E1EC91C1BA&displaylang=en

After uploading sda file as per the document we are getting the

attached error. also the changes are not refelecting in the visual

admin tool.

error message :

JDBC message processing failed; reason 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:sqlserver://10.235.2.26:1433:databaseName=test': ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Regards

Gunaseelan