PRB: "ODBC Resource DLL Is a Different Version Than ..." Error

Last reviewed: March 16, 1998
Article ID: Q170769

The information in this article applies to:

Microsoft Open Database Connectivity, versions 3.0 and 3.5
Microsoft Visual InterDev, version 1.0

SYMPTOMS

After installing or upgrading ODBC files, you receive one of the following error messages:

   The ODBC resource DLL (c:\windows\system32\odbcint.dll) is a different
   version than the ODBC driver manager (c:\windows\system\odbc32.dll).

   -or-

   The ODBC resource DLL (c:\windows\system\odbcint.dll) is a different
   version than the ODBC setup dll (c:\windows\system\odbccp32.dll).

   -or-

   The ODBC resource DLL c:\windows\system\odbcint.dll) is a different
   version than the administrator (c:\windows\system\odbcad32.dll).

The message may appear periodically on your screen or when you attempt to open the ODBC Administrator.

CAUSE

Many applications install ODBC, including Visual InterDev, Active Server Pages, Windows NT 4.0 Service Pack 3, and many others. During the installation of ODBC, a service or application was using one or more ODBC files. The files that were in use could not be overwritten, causing a version mismatch between the files that were in use and either the ODBC Driver Manager or the ODBC Administrator.

Because the ODBC 3.0 and 3.5 Driver Manager performs automatic version checking between itself and the other ODBC core components, it detects the version mismatch and begins generating a warning.

WORKAROUND

To work around this problem, perform the steps below corresponding to the operating system you are running.

For computers running Windows NT

Move or remove shortcuts in the Startup group for any applications that use ODBC.
Open Control Panel and double-click the Services icon. Look for any services that use ODBC whose Startup mode is set to Automatic. Set the Startup mode of these services to Manual. These services typically include:
```
      SQLExecutive
      MSSQLServer
      Internet Information Server (WWW, Gopher and FTP)
```
Restart the computer.
Reinstall ODBC, or copy files with the correct version into the Winnt\System32 directory.
Set the Startup mode of the previously changed services back to Automatic and restart the services.

For computers running Windows 95

Move or remove shortcuts in the Startup group for any applications that use ODBC.
If Personal Web Server is installed on the computer, set the startup mode so it will not run automatically at startup.
Restart the computer.
Alternatively, restart Windows 95, and hold down the SHIFT key while it is restarting. Doing this will start Windows 95 in safe mode, and will bypass most applications that load at startup.
Reinstall ODBC, or copy files with the correct version into the Windows\System directory.
Restart your applications.

MORE INFORMATION

You can download ODBC version 3.0.2301 from:

   http://support.microsoft.com/support/downloads/dp2445.asp

You can download ODBC version 3.0.2822 (ODBC 3.0 Service Pack 1) from:

   http://www.microsoft.com/odbc/download/x86/odbcdmin.exe

   -or-

   ftp://ftp.microsoft.com/developr/ODBC/public/odbcdmin.exe

You can download ODBC version 3.5 (MDAC) from:

   http://www.microsoft.com/data

If you are installing ODBC 3.5, see the following article(s) in the Microsoft Knowledge Base:

   ARTICLE-ID: Q177136
   TITLE     : INFO: Required Files to Install MDAC 1.5
               (ODBC/OLEDB/ADO/RDS)

The ODBC core files are usually listed in the ODBC Administrator (on the About tab), and are located in the Windows\System folder. They consist of the following files:

   Odbccp32.dll   ODBC Administrator DLL
   Odbccp32.cpl   Control Panel Device
   Odbcad32.exe   Control Panel Startup
   Odbccr32.dll   Cursor Library
   Odbc32.dll     Driver Manager
   Odbcint.dll    Localized Resource DLL

The following files are not shown in Control Panel ODBC Administrator, but may contribute to the problem. They are also located in the Windows\System directory:

   Odbcstf.dll    Setup file
   Odbctrac.dll   Trace functions
   Odbc16gt.dll   Thunking file
   Odbc32gt.dll   Thunking file
   Ds16gt.dll     Thunking file
   Ds32gt.dll     Thunking file

Additional query words: reboot machine sp sp1
Keywords : odbcErrmsg
Technology : kbInetDev
Version : WINNT: 3.0 3.5
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 16, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.