Skip to Content
avatar image
Former Member

SAP PI 7.11 JDBC tyoe 4 driver for MS SQL Server

HI All,

I have a SAP PI system with following details:

     SAP PI version - 7.11

     Operating System - Windows 2008 server

     JDK - JDK 1.5

For a integration scenario, i need to connect to a third party system, which is a MS SQL server 2008.

I am hence installing JDBC type 4 driver for connecting to that database using JDBC Channel.

I have followed the following steps for installing the JDBC driver:

Step 1. Download the SQL JDBC 3.0 drivers file from http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en

i have downloaded the exe version of the driver - 1033\sqljdbc_3.0.1301.101_enu.exe

Step 2. Unzipped the driver exe in a folder. On unzipping i found two jar files - sqljdbc4.jar and sqljdbc.jar, and many dll files.

Please suggest me what are the next steps for completing the installation of the JDBC driver....

Thanks and regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 09, 2013 at 07:18 AM

    Hi Sudeep,

    Please look at the link http://scn.sap.com/message/14281383

    You can deploy sqljdbc4.jar and then try communicating with DB.

    Ambrish

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 09, 2013 at 06:30 AM

    Hi Suddep,

    Have you check Former Member's document http://scn.sap.com/docs/DOC-3825?

    Regards.

    Add comment
    10|10000 characters needed characters exceeded