SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

657 Views

Hi...Experts....

Requirement:

From our PI 7.1 System we have to connect to MS-SQL Server 2000 using JDBC.

Execution :

We have downloaded

Microsoft SQL Server JDBC Driver 3.0 ...and...Microsoft SQL Server JDBC Driver 2.0 ( We mean we tried both drivers)and deployed using JSPM in PI system

To deploy this ..We used & reviewed the following notes

Note 0000831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Note 0001138877 - PI 7.1 : How to Deploy External Drivers JDBC/JMS Adapters

Note 0000850116 - XI 3.0 / PI 7.0 JDBC Adapter: Type 2 JDBC Driver Deployment

Note 0001123333 - Redeploying same component with JSPM

Issue Observation Path :

in JSPM ...The deployment is successfull

But in

>Runtime Workbench NetWeaver Administrator

>>Component Monitoring

>>>Compnenet with status ..ALL...[DISPLAY]

>>>Adapter Engine

>>>>Communication Channel

We continuioulsy see the following error

ERROR :

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

ERROR:

In this Juncture...We have 2 queires.

01. How to make the Deployed JDBC Driver avaialbiliy in the system.

02. Any other alternate way to make sure our self deployed JDBC well installed in system and can be used from PI Console.

Regards

PR