Skip to Content

Regarding JDBC driver

hello experts,

I have a requirement in my project where i need to install the JDBC driver for Windows server. I am using the PI 7.3 version.

Following are the details :

Database (Vendor) Name, : Microsoft SQL Server

Database Version : 2008 R2.

Please suggest which JDBC driver i need to install.

I was seaching in scn and found the below driver details for PI 7.1x in microsoft site:

Driver name is MS-SQL JDBC driver 3.0 and the driver
file name for windows is sqljdbc_3.0_1301_enu.exe.

Please let me know whether same is applicable for PI 7.3 as well or need another driver?

Please share the s-note for reference.

Thanks in advance

Geetanshi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2014 at 02:34 PM

    Hi Geetanshi,

    You need to download the .jar files that you want to include in the SDA which you're about to deploy via SUM to PI system.

    The followings might be helpful for you:

    - SAP Note 831162 - Question 13.

    - http://scn.sap.com/docs/DOC-3817 - how to prepare the SDA file (also valid for 7.3x!)

    - Download Microsoft SQL Server JDBC Driver 3.0 from Official Microsoft Download Center - Microsoft's official download website for JDBC driver 3.0

    However, it depends on your need which JDBC driver you'd like to use. Version 4.0 is also available. It's important though to have JDK 1.5 or above if you're using PI 7.3x or above release.

    Best regards,

    Bálint

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.