jdbc driver infromation required for mssql 2000 sp...

Former Member · ‎09-19-2005

Hi Gurus,

we got requirement of usage of JDBC adapter to read data from mssql 2000 sp3 database. We are using sapxi 3.0.

we downloaded latest driver and deployed as per guidelines from sap.

I am getting error 'No suitable driver' in RWB when my scenario is executed.

Can any body give information which is suitable driver i have to deploy for jdbc connection for mssql 2000 sp3 for connecting with sapxi.

regards,

pvrao.

Former Member · ‎09-19-2005

I think you did not deploy the driver properly.

Then the problem would have been during unzip/zip of SDA.

Ok...try these steps again with care.

1. From ur XI server get the aii_af_jmsproviderlib.sda and

copy in local drive say F:/test

2. rename the aii_af_jmsproviderlib.sda to aii_af_jmsproviderlib.zip

3. Right click on this zip and click on extract to here.

4. U'll see in F:/test server,meta-inf folders

and other jars if any.

5. Now in F:/test copy the three SQL jars.

6. Edit the provider.xml in F:/test/server as following

<jars>

<jar-name>msbase.jar</jar-name>

<jar-name>mssqlserver.jar</jar-name>

<jar-name>msutil.jar</jar-name>

</jars>

7. Delete the old aii_af_jmsproviderlib.zip file from

F:/test

8. select all files and folders in f:/test, then right

click on any folder or file and Winzip-->add to zip file

9. Give the name as aii_af_jmsproviderlib.zip

10. Either u can use this Zip file or rename it as aii_af_jmsproviderlib.sda to deploy using SDM

regards

SKM

Former Member · ‎09-19-2005

HI

The drivers which u require for JDBC adapters are

<b>msbase.jar, mssqlserver.jar, msutil.jar</b>

For deploying these jars, go thru this article

Regards

Arpit Seth

jdbc driver infromation required for mssql 2000 sp3