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

[joo_migueldimas]

Hello to all,

This is the second post that I created reporting this error because in the first one I open this message in group of "SAP on SQL Server" but without any kind of help from community:

My problem is...

I´m planning to do an upgrade of a sap system (SAP ECC 6.0) from SQL Server 2005 to a 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

[joo_migueldimas]

Hello there,

I finished all activities relation to this issue! Answer to my own question, what I did was after finish the SQL Upgrade with SQL tool provide by Microsoft... I had to delete the software of the old version (SQL 2005)! For this I stopped the SAP and SQL services and delete the old version of SQL in Add or Remove Programs (in Control Panel - at Windows). After this I started the services and sap system!!

Note: If you are unsure what version of SQL is being used by the system you can check this in Database data on System --> Status .

Best regards,

João Dimas - Portugal

Edited by: João Dimas on Jul 13, 2010 9:48 AM

[Former Member]

Hi,

Have you considered the possibility that the directory that was supposed to contain the jdbc drivers has been replaced by a recent kernel upgrade and you never noticed?

Anyway, looking forward, put in a new set of JDBC drivers in the correct location.

Also, with reference to the following point from the first note:

Check your JDBC Driver version before you download it. To do this, unpack the attached check tool SAPCheckVersion in the relevant JDBC directory (refer to the previous paragraph). Then open a command prompt there and execute the following command:

SAPCheckVersion.cmd <server name> <username> <password>

Replace <server name> with the name of the database server, <username> and <password> with the logon data of an SQL user (for example, sa or SAP<SID>DB). If you call SAPCheckVersion.cmd without a parameter, the system displays detailed help. The tool supports both DataDirect and Microsoft drivers.
*The download name tells you which version of the driver you need to download from SAP Service Marketplace.*

Run this SAPCheckVersion and find out which drivers you need to download and then download them and use them.

Regards,

Shitij

[joo_migueldimas]

Hello Shitij Bagga,

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

[joo_migueldimas]

Hello Shitij Bagga,

Even though this thread is already closed, I still have another question...! I´ll open for this question...

Can you tell me another thing regarding the post upgrade of MS SQL 2005 to 2008?.. I already finished this task but after finished this platform upgrade I noticed the system did not uninstall the SQL Server 2005 automatically... althout I see in there the SQL Server 2008 it still have install the SQL Serve 2005 on windows server programs! So, my question is simple, I will have to do this manually through Add/Remove Programs option on Control Panel? And if so, this action may have some impact...? The database instance (SAP) recognizes the SQL Server 2008 after I delete the old one platform (SQL Server 2005)?

Kind regards,

João Dimas - Portugal