MDAC - ODBC mismatches

[Seanl]

I installed MDAC 2.8 on a windows 2000 server. (it was a
requirement to install BKexec version 9.1). BKexec uses an
msde sql database. When i go into the odbc connections, i
get an error message stating that there is a version
mismatch fot the odbc files. I ran the component checker,
and sure enough there were a couple of files mismatched.
I then stopped all the services that were not necessary,
and reinstalled the MDAC package. Still had the same
issue. I then installed the Jet4 SP8, and still no luck.
Can anyone help me out here, i'm at my wits end.

Sean

 

[George Hester]

It depends what your mismatches are. If the versions are higher then what Component Checker says they should be you do not have a problem. That is fine. Remember Component Checker only recognizes 2.7 and less. And it is buggy. So what are the dlls where the mismatches occur and are they all dlls?

 

[Guest]

specific error is: the odbc resource dll (c:\winnt\system32
\odbcint.dll) is a different version than the
administrator (c:\winnt\odbcad32.exe)
The odbccad32.exe is version 2.8
the mismatched files are :
odbcint.dll ver 3.520.9001.0 should be 3.525.1022.0
same applies to odbccp32.dll and odbc32.dll

then oledb32.dll version 2.71.9042.0 should be 2.80.1022.0
and oledb32r.dll version 2.70.9001.0 should be 2.80.1022.0

and lastly i also get msado15.dll, msadrh15.dll,
msdaps.dll, msxactps.dll version 2.71.9030.0 should be
2.80.1022.0

 

[George Hester]

Well we definitely have an issue. MDAC issues are difficult to fix. The reason why is because the method of reverting to a previous MDAC version rarely works and the only sure fire way of doing it is to reinstall the operating system. I am not saying that is your only alternative but I'm just trying to point out the issue you are having is not uncommon.

http://support.microsoft.com/default.aspx?scid=kb;en-us;170769

First I am surprised that Component Checker is telling you you should have version 2.8.xx ODBC versions. I suppose Component Checker has been updated since I last used it. Mine only hase a database for 2.7.xx ODBC versions.

I would look in Visual Basic or any VBA application under references and see if you have 2.8 ADO versions in there. If so then try to include those and see if you get an error. If you don't then that is the version you are currently using.

http://support.microsoft.com/default.aspx?scid=kb;en-us;294374&Product=win2000

http://support.microsoft.com/default.aspx?scid=kb;EN-US;307255

I would uninstall your version of Office. Reboot. Then I would (re)install SP3 or higher in Windows 2000 while in Safe Mode. Reboot. Then I would install the latest MDAC 2.7. Reboot. Then I would reinstall Office. Reboot. Then I would re-install MDAC 2.8. Reboot. Still same error?

 

[George Hester]

Here I stand corrected. Component Checker does have 2.8 in the database. Here are my version mismatches and I have never install MDAC 2.8. Why these are looking for 2.8.x versions is beyond me all I know is I don't have the issue you mention:

- <group name="MISMATCH" count="11">
- <file name="CLICONFG.DLL" dir="%SYSTEMDIR%\">
<release name="MDAC 2.7 SP1 Refresh" version="2000.80.380.0" />
<found Description="SQL Client Configuration Utility DLL" date="09/26/2002" fileVersion="2000.085.1014" size="73728" version="2000.85.1014.0" />
<result mismatch_fields="version" />
</file>
- <file name="CLICONFG.EXE" dir="%SYSTEMDIR%\">
<release name="MDAC 2.7 SP1 Refresh" version="2000.80.380.0" />
<found Description="SQL Client Configuration Utility EXE" date="09/26/2002" fileVersion="2000.085.1014" size="20480" version="2000.85.1014.0" />
<result mismatch_fields="version" />
</file>
- <file name="ODBC32.dll" dir="%SYSTEMDIR%\">
<release name="MDAC 2.7 SP1 Refresh" version="3.520.9030.0" fileversion="3.520.9030.0" />
<found Description="Microsoft Data Access - ODBC Driver Manager" date="10/28/2003" fileVersion="3.520.9042.0" size="204800" version="3.520.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="ODBCBCP.DLL" dir="%SYSTEMDIR%\">
<release name="MDAC 2.7 SP1 Refresh" version="2000.81.9031.38" />
<found Description="Microsoft BCP for ODBC" date="10/28/2003" fileVersion="2000.081.9042.00" size="24576" version="2000.81.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="odbccp32.dll" dir="%SYSTEMDIR%\">
<release name="MDAC 2.7 SP1 Refresh" version="3.520.9030.0" fileversion="3.520.9030.0" />
<found Description="Microsoft Data Access - ODBC Installer" date="10/28/2003" fileVersion="3.520.9042.0" size="98304" version="3.520.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="OLEDB32.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.7 SP1 Refresh" version="2.71.9031.4" fileversion="2.71.9031.4 built by: Lab06_N(dagbuild)" />
<found Description="Microsoft Data Access - OLE DB Core Services" date="10/28/2003" fileVersion="2.71.9042.0 built by: Lab06_N(_sqlbld)" size="417792" version="2.71.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="SQLOLEDB.DLL" dir="%COMMONFILES%\system\ole db\" CoreFile="Yes">
<release name="MDAC 2.7 SP1 Refresh" version="2000.81.9031.18" />
<found Description="Microsoft OLE DB Provider for SQL Server" date="10/28/2003" fileVersion="2000.081.9042.00" size="471040" version="2000.81.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="SQLSRV32.DLL" dir="%SYSTEMDIR%\" CoreFile="Yes">
<release name="MDAC 2.7 SP1 Refresh" version="2000.81.9031.38" />
<found Description="Microsoft SQL Server ODBC Driver" date="10/28/2003" fileVersion="2000.081.9042.00" size="385024" version="2000.81.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="dbnetlib.dll" dir="%SYSTEMDIR%">
<release name="MDAC 2.7 SP1 Refresh" version="2000.81.9031.3" />
<found Description="Winsock Oriented Net DLL for SQL Clients" date="10/28/2003" fileVersion="2000.081.9042" size="61440" version="2000.81.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="msdart.dll" dir="%SYSTEMDIR%" CoreFile="Yes">
<release name="MDAC 2.7 SP1 Refresh" version="2.71.9031.4" />
<found Description="Microsoft Data Access - OLE DB Runtime Routines" date="10/28/2003" fileVersion="2.71.9042.0 built by: Lab06_N(_sqlbld)" size="126976" version="2.71.9042.0" />
<result mismatch_fields="version" />
</file>
- <file name="cliconfg.rll" dir="%SYSTEMDIR%">
<release name="MDAC 2.7 SP1 Refresh" version="2000.80.380.0" />
<found Description="SQL Client Configuration Utility Resource DLL" date="09/26/2002" fileVersion="2000.085.1014" size="24576" version="2000.85.1014.0" />
<result mismatch_fields="version" />
</file>
</group>

And since I'm a great advocate of "leave well enough alone" I'm not going to try to fix these although I probably should.