Upgrade MS SQL 2005 platform to MS SQL 2008 - Update the JDBC driver issue

[joo_migueldimas]

Hello to all,

I´m planning to do an upgrade of a sap system (SAP ECC 6.0) from SQL Server 2005 to an SQL Server 2008 but I´m facing with a little problem. This system has two stacks - ABAP + JAVA - and because of that the Upgrade Guide to MS SQL Server 2008 describe which are the requirements for this upgrade DB platform, and one of them is this:

"If you use a Java system, you have updated the JDBC driver as described in SAP Note 639702"

... the updated of JDBC driver when we have in system a Java part, like it has in this case! But I´m with a serious problems to find in SAP System Files in Windows 2003 Server the four files that is mentioned in that note 639702. I can´t find it anywhere... in note says:

Depending on the SAP release and the system configuration, the driver files base.jar, util.jar, sqlserver.jar, and spy.jar are available in an installed system at:
(NetWeaver'04, Java:) usrsap<SAP SID>JC<InstanceNumber>j2eejdbc
(NetWeaver'04, ABAP+Java:) usrsap<SAP SID>DVEBMGS<InstanceNumber>j2eejdbc
(NetWeaver 2004s:) usrsap<SAPSID>SYSexe<NUC|UC>Platformmssjdbc

But... still I didn´t find them! I also read other note 1109274 - New JDBC driver for NetWeaver 7.0 and higher but even so I still can´t find it!

Can you help me to find this files on my operation system? I have to update that JDBC... but of course for this task I have to find it first!!!

Best regards,

João Dimas - Portugal

[former_member189546]

The files are usually located in:

usr\sap\<SAPSID>\JC<InstanceNumber>\j2ee\jdbc

Please, check the note 639702 for further details.

If the files are not in this directory, then please download and

import the JDBC driver as per note 639702.

regards,

John Feely

[joo_migueldimas]

Hello John Feely,

Yeah I already know that you mentioned! In my first post/previous message I mentioned that, I already read the note 639702 and it was there I read that explanation... regarding that creation that you refer in the case of files are not in those directories, so you said that I could download this four files and put in there... but where? and how..? Sorry but that solution seems does not make any sense!

I also look other systems with double stack ABAP + JAVA and I one more time I didn´t see that directories or files that are mentioned in that note!! DAMN!

Any tip?

Kind regards,

João Dimas - Portugal

[joo_migueldimas]

Hi John Feely,

I already finish the SQL Server upgrade (from 2005 to 2008 version).

Before the upgrade procedure I had this little doubt and what I did to pass this issue was install the JDBC driver like it was the first time, like if the system hadn´t that driver path! Finally after this I procedure with upgrade task as it mentioned in the Upgrade Guide!!

I had opened another post in other group with the same question:

So thank you for trying to help me.

Best regards,

João Dimas - Portugal