SAP PI 7.11 JDBC tyoe 4 driver for MS SQL Server

[Former Member]

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&displa...

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

[ambrish_mishra]

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

[Former Member]

Thanks..all.. i Think i should be using sqljdbc and not sqljdbc4.jar..

I found this difference between sqljdbc.jar and sqljdbc4.jar

sqljdbc.jar

sqljdbc.jar class library provides support for JDBC 3.0. sqljdbc.jar class library requires a Java Runtime Environment (JRE) of version 5.0. Using sqljdbc.jar on JRE 6.0 or JRE 7.0 will throw an exception when connecting to a database. Note The JDBC Driver does not support JRE 1.4. You must upgrade JRE 1.4 to JRE 5.0, JRE 6.0, or JRE 7.0 when using the JDBC Driver. In some cases, you might need to recompile your application because it might not be compatible with JDK 5.0 API or JDK 6.0 API. For more information, see the documentation on Sun Microsystems Web site. Microsoft JDBC Driver 4.0 for SQL Server does not support JDK 7.

sqljdbc4.jar

sqljdbc4.jar class library provides support for JDBC 4.0 API. It includes all of the features of the sqljdbc.jar as well as the new JDBC 4.0 API methods. sqljdbc4.jar class library requires a Java Runtime Environment (JRE) of version 6.0 or 7.0. Using sqljdbc4.jar on JRE 5.0 will throw an exception. Note Use sqljdbc4.jar when your application must run on JRE 6.0 or 7.0, even if your application does not use JDBC 4.0 API features.

[iaki_vila]

Hi Sudeep,

You are right, for driver version 2.0 and higher, JVM1.5 and JVM1.6 are supported by different  files; sqljdbc.jar (JVM1.5) and sqljdbc4.jar (JVM1.6), SAP PI 7.1X runs in JVM 5.1 then is better to use sqljdbc.jar

Regards.

[ambrish_mishra]

If driver sqljdbc.jar suits your requirement, well and good but please do note that all drivers are down-compatiable.

Please close the thread if your question is answered.

cheers

[Former Member]

thanks ambrish and Vila

[iaki_vila]

Hi Suddep,

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

Regards.