How do I deploy the SQLServer 2000 JDBC Driver?

Hi all,

I created a datasource through the visual admin, added the three jar files associated with the MS SQLServer 2000 jdbc driver to the datasource, saved, and then bounce the J2EE server.

In the Integration Directory I configured the driver to

be <b>com.microsoft.jdbc.sqlserver.SQLServerDriver</b>.

When calling the JDBC Adapter, I get the following error:

com.sap.aii.af.ra.ms.api.DeliveryException: JDBC Adapter Receiver Channel jdbcSCADA: Configuration not initialized due to Loading jdbc <b>driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver'</b> failed: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver Found in negative cache -

Loader Info -

ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc] Parent loader name: [Frame ClassLoader] References: service:com.sap.aii.af.cpa.svc service:com.sap.aii.af.ms.svc service:com.sap.aii.af.svc service:com.sap.aii.adapter.xi.svc library:com.sap.aii.af.lib library:com.sap.aii.messaging.runtime library:com.sap.xi.util.misc common:service:iiop;service:naming;service:p4;service:ts common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:com.sap.security.core.ume.service;service:connector;service:dbpool;service:keystore;service:security;service:userstore library:ejb20 library:sapxmltoolkit library:com.sap.guid library:com.sap.tc.Logging library:jms Resources: /usr/sap/XID/DVEBMGS00/j2ee/cluster/server0/bin/services/com.sap.aii.adapter.jdbc.svc/aii_adapter_jdbc_svc.jar Loading model: {parent,local,references} -

Available JDBC drivers: No deployed JDBC Drivers

As you can see in the error, the jdbc driver is trying to load the SQLServerDriver class but can't find it. Is there anything besides adding a datasource I need to do for the JDBC driver to find the SQLServerDriver class?

Regards,

--jtb