on 09-07-2013 12:44 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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. |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
9 | |
9 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.