639702 - JDBC Driver for Microsoft SQL Server

[former_member206857]

Hi All,

I've been working towards upgrading my SQL 2008 R2 Sp2 to SQL 2012.

I've completed all my ERP's.

Now I am looking at my SOLMAN and PI installations. Both are dual stacks.

In the manual it clearly states to "

　

　

Java system, you have updated the JDBC driver as described in SAP Note 639702

Im on my Solman 7.1 SP10.

Following the note, I used the utility to determine my version:

Found Microsoft JDBC Driver.

Driver version is : 1.2.2828.215

JDBC version: 3.0

My confusion starts here.

For installations based on SAP NetWeaver 7.0 SR3 and higher, "Microsoft SQL
Server JDBC Driver" that is delivered officially from Microsoft is used. It
consists of the file sqljdbc.jar.
The following applies to this release and
this driver:

This statement from the note confuses me!

• You can download the latest version of the "Microsoft SQL Server JDBC
  Driver" from the Microsoft download page; for example:

• "Microsoft SQL Server 2005 JDBC Driver 1.2" for SAP releases based on SAP
  NetWeaver releases between 7.0 and 7.11: This download is no longer provided by
  Microsoft. If required, you can download the driver from SAP Service
  Marketplace:
  http://service.sap.com/swdc
  > Database and Database
  Patches (from other vendors)
  > MS SQL Server > Database Patches >
  MICROSOFT JDBC > MS SQL SERVER 2005 JDBC 1.2 > MS SQL SERVER >
  Microsoft SQL Server 2005 Driver for JDBC version 1.2

So am I downloading it from MS or SAP? I checked both, I see 3.0 on SAP's site and I see 4.1 on MS site.

Any advice or direction here? What should I do?

[former_member184473 · Accepted solution]

Hello Joshua,

It depends which JVM version is implemented in your java systems.

Check note 1745895 for further information.

Basically:
- if JVM 1.4 = JDBC 1.2

- if JVM 1.5 or 1.6 = JDBC 2.0, 3.0 or 4.0

Regards,

Eduardo Rezende

SAP Support

[former_member206857 · Accepted solution]

That makes sense! I got JVM 1.4 and JDBC 1.2/

ok got it, thanks