External JDBC drivers for sqlserver 2000 and SAP PI 7.0 on Linux

[Former Member]

Hi Experts,

I have to install external jdbc drivers to sqlserver 2000 from SAP PI 7.0 which is running on linux.

browsed so many blogs , discussions and in service marketplace ,I could not find the correct driver jar files.

I saw that Microsoft is not giving supporting for sqlserver 2000 jdbc drivers.

I downloaded the below drivers and tried to deploy with SDM,seems these were deployed.but do not see the deployed jar files in Visual admin--> JDBC Connector-->Drivers-->aii_af_jmsproviderlib

MS SQL Server-->Database Patches-->MICROSOFT JDBC-->MS SQL SERVER 2005 JDBC 1.2-->

MSJDBC12SP00_0-10010442.ZIP

Microsoft SQL Server 2005 Driver for JDBC version 1.2

Please suggest me where can I get the correct drivers.

Your help will be most appreciated

Thanks in advance.

Best Regards,

Sai

[Former Member · Accepted solution]

Hi All,

The issue is solved .I took.SDA file from software downloads dump and selected appropriate options on SDM tool.

Thanks for your inputs.

[Reagan]

Hello

Check this guide

http://scn.sap.com/docs/DOC-3825

Regards

RB

[former_member185239]

Hi Sai,

Please find the article below

1. http://scn.sap.com/message/196269

2. http://scn.sap.com/people/charu.agarwal/blog/2009/07/02/problems-faced-while-connecting-to-sql-serve...

You can download the jdbc drivers by following the sapnote

639702 - JDBC Driver for Microsoft SQL Server

How to apply the patches  (which depends on your PI Version /XI version)

1138877 - How to Deploy External Drivers JDBC/JMS Adapters

Procedure to apply the drivers

1770304 - PI: How to prepare the com.sap.aii.adapter.lib.sda for deployment

1770206 - PI: How to extract the archive for deploying 3rd party drivers

With Regards

Ashutosh Chaturvedi

[former_member185239]

Hi Sai,

Also follow the below sapnote

1745895 - Available Microsoft JDBC drivers

With Regards

Ashutosh Chaturvedi