English

Error: Reinstall the odbc components in order to ensure proper operation

Solution or Workaround

Summary

Starting ArcView produces this message:

"the odbc resource dll c:\winnt\system32\odbcint.dll is a different version than the odbc driver manager c:\winnt\system32\odbc32.dll. You need to reinstall the odbc components in order to ensure proper operation."

Clicking OK allows ArcView to start but it cannot make ODBC connections.

Cause

There are at least two possible causes: The operating system was installed without the ODBC components, or

The ODBC core components were overwritten by the installation of Service Pack 3 or some application, after installing ArcView 3.1.

Solution

Warning:
WARNING: The instructions below include making changes to essential parts of your operating system. It is recommended that you backup your operating system and files, including the registry, before proceeding. Consult with a qualified computer systems professional, if necessary.

ESRI cannot guarantee results from incorrect modifications while following these instructions. Therefore, use caution and proceed at your own risk.


Navigate to Start/Settings/Control Panel and click on the ODBC32 icon.

If there is no ODBC32 icon, the OS was installed without ODBC. Reinstall the OS and make sure you select the ODBC components.

If there is an ODBC icon, double-click the icon to open the ODBC Administrator. Select the About tab and look at the versions of the ODBC core components. Most likely the ODBC32.dll file is a later version than the other components. If that is the case, reinstalling ArcView 3.1 should get all the core components updated to the same version.