Error when connecting to MSSQL server using JDBC driver

[Former Member]

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

[Former Member · Accepted solution]

hi,

u should need to deploy JDBC Drivers.this is drivers problem only.

Thnx,

Siva Nagaraju.

[Former Member]

Thanks,

The issue is resolved.

Solution:

AS undeployed and redeployed the driver.

Regards,

Gunaseelan

[prateek]

This error simply means that the drivers are not installed properly on PI. Reinstall them.

Regards,

Prateek