Regarding JDBC driver

[geetanshi_kakkar]

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

[Former Member · Accepted solution]

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

[geetanshi_kakkar · Accepted solution]

Apologies for late reply thanks for your inputs