INF: Incorrect Versions of Odbcint.dll Can Affect Components

 Last reviewed: January 28, 1998
Article ID: Q179476
The information in this article applies to:
  • Microsoft SQL Server version 6.0 and 6.5

SYMPTOMS

In some situations the ODBC DLL file, Odbcint.dll, is no longer synchronized with the other ODBC DLLs. This can cause an Odbcint.dll version error to occur when you start ODBC-dependent applications. When you start an ODBC application, you receive the following error message: 

   The ODBC resource DLL (odbcint.dll) is a different
   version than the ODBC driver manager (ODBC32.DLL).

   You need to reinstall the ODBC components to ensure proper operation.
In most situations the client application continues to function partially or it may not function at all. The functionality losses or abnormal behavior can vary widely from application to application.

Odbcint.dll version problems can also affect SQL Server and SQL Executive. For additional information about the effects on the SQL Server service, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q175398
   TITLE     : PRB: SQL Server May Appear to Stop Responding Upon Startup
When the SQL Executive service is affected, it does not start scheduled tasks and does not shut down correctly when you issue a service shutdown request. When you try to execute any task, you receive the following error message: 

   Error 21003: [SQL Server] Error executing xp_schedulersignal
   extended stored procedure: SQLExecutive not running
ODBC problems can also affect SQL Server extended stored procedures. When you restart the SQL Server service, if you click Cancel when the error message about the DLL mismatch appears, a call to either xp_cmdshell or xp_logevent may cause the server to freeze. Existing connections to the server are not allowed to proceed and new connections to the server can not be made. You must restart the server. If you click OK on the error message dialog box, then subsequent calls to xp_cmdshell or xp_logevent are honored.

CAUSE

By default, the SQL Server service is started using the local system account and is allowed to interact with the desktop. When SQL Server is started, an error message warning of the Odbcint.dll mismatch is displayed, however the SQL Executive service is set up to start under a given account and not interact with the desktop. When SQL Executive starts, it does not display the error message warning of the Odbcint.dll mismatch.

SQL Executive appears to be working in the SQL Service Manager and the SQL Enterprise Manager but no tasks can be started. Starting tasks from the Enterprise Manager or executing xp_schedulersignal gives error 21003 (see the "Symptoms" section).

WORKAROUND

To permanently resolve this problem, update your ODBC components so that they all have compatible file versions. To do this, quit all ODBC-related applications and reinstall ODBC. The ODBC setup files that are included with SQL Server are available on the SQL Server CD in the \i386\ODBC directory.

For additional information, please see the following article in the Microsoft Knowledge Base: 

   ARTICLE-ID: Q170769
   TITLE     : PRB: "ODBC Resource DLL Is a Different Version
               Than ..." Error


Keywords          : SSrvGen
Version           : WinNT:6.0,6.5
Platform          : winnt
Issue type        : kbprb

================================================================================

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: January 28, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.