SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

[Former Member]

Hi,

We are having one Scenario in which we are using JDBC as Sender Adapter , when we try to fetch data from MS SQL Server 2005 it gives an error :

Error during database connection to the database URL 'jdbc:sqlserver://XXXXXXXXX:1433;databaseName=nbcc_test' using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://XXXXXXXXX:1433;databaseName=nbcc_test': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver'

Even we have deployed the Java Class file for JDBC Driver but have no effect on error.

Thanks & Regards,

RP

[Former Member]

Hi,

have you built the JDBC driver file correctly and deployed it correctly in your XI server............if you have, then do a complete CPACache refresh by asking your basis guys to do it and then re-run your scenario.

Regards,

Rajeev Gupta

[Former Member]

Hi Rajeev,

Thanks for you suggetion but it giving same problem still.

We have already deployed the JDBC file, can u just tell me which file(name) I have to deploy for MS SQL Server 2005 and how do I check whether it's uploaded properly or not.We are using PI 7.0.

Thanks,

RP

[Former Member]

Issue has been resolved.

Just by deploying correct file sqljdbc.jar in the PI system.

Thanks to all.

[Former Member]

Hi,

can you give your version of SQL server ,JDBC driver for SQL server and on which OS you deployed,

Please give your comments on my latest post about the same issue.