DBACOCKPIT There are different versions of ODBC32.dll in use

[Former Member]

Hi all,

In dbacockpit if you go to Configuration and SQL Server Setup Check.

Got this error u201CThere are different versions of ODBC32.dll in useu201D

How do I fix this?

[Former Member]

Check and update MDAC of your application server.

Regards

Surjit

[Former Member]

Hi Surjit,

Microsoft says you can look in the registry to see MDAC versions both DEV and QA are on 6.0.6002.18005

I have compared DEV to QA and have noticed that on the central instance server in ODBC Data Source Administrator on the About tab

the Driver Manager C:\Windows\system32\odbc32.dll is 6.0.6002.18326 and on DEV its 6.0.6002.18005 so this must be the cause.

We are thinking that a Windows service pack upgraded the dll.

[Former Member]

Hi Gareth Bosman,

For exact information about ODBC32.dll versions used, go to ST04 --> Diagnostics --> DISP+WORK DLLs

Here you can find the exact hostnames and all different versions of ODBC32.dll used.

Check and take the corrective steps either by updating MDAC or applying microsoft's recommended patches for that particular host only.

By the way, as per my observations, even continuing with multiple versions of ODBC32.dll will not affect smooth working of your application. you can update it at later times also.

Regards

Surjit

[markus_doehr2]

What version are you runinng DBACOCKPIT?

Check

Note 1134800 - different versions of SQLNCLIR.RLL

Markus

[Former Member]

Hi Markus,

Component: SAP_BASIS

Software C: 711

SP-Level: 0006

Support Package: SAPKB71106

I read the note you suggested but it looks like it refers to 700 and not 711, sorry for not posting my SAP_BASIS version earlier

Regards,

Edited by: Gareth Bosman on Aug 2, 2011 2:05 PM