DOCUMENT:Q127734  28-SEP-2001  [visualc]
TITLE   :HOWTO: Ensure ODBC.DLL and ODBCCURS.DLL Cursor Levels Match
PRODUCT :Microsoft C Compiler
PROD/VER::1.5,1.51,1.52,2.0,2.1,2.2,2.5,2.6,4.1,4.2,5.0,6.0
OPER/SYS:
KEYWORDS:kbenv kbDatabase kbMFC kbODBC kbVC kbGrpDSVCDB kbGrpDSMDAC kbDSupport kbMDAC200 kbMDAC1

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - The Microsoft Foundation Classes (MFC), used with:
    - Microsoft Visual C++ for Windows, 16-bit edition, versions 1.5, 1.51, 1.52 
    - Microsoft Visual C++, 32-bit Editions, versions 2.0, 2.1, 2.2, 4.1 
    - Microsoft Visual C++, 32-bit Enterprise Edition, version 4.2 
    - Microsoft Visual C++, 32-bit Professional Edition, version 4.2 
    - Microsoft Visual C++, 32-bit Enterprise Edition, version 5.0 
    - Microsoft Visual C++, 32-bit Professional Edition, version 5.0 
    - Microsoft Visual C++, 32-bit Enterprise Edition, version 6.0 
    - Microsoft Visual C++, 32-bit Professional Edition, version 6.0 
    - Microsoft Visual C++, 32-bit Learning Edition, version 6.0 
 - Microsoft Data Access Components versions 1.5, 2.0, 2.1, 2.5, 2.6, 2.7 
-------------------------------------------------------------------------------

SUMMARY
=======

The ODBC Driver Manager and the Cursor Library must have the same cursor level.
ODBC.DLL and ODBCCURS.DLL are the corresponding files in 16-bit Windows.
ODBC32.DLL and ODBCCR32.DLL are the corresponding files in 32-bit Windows.

Attempting to use these dynamic link libraries with mismatched cursor levels will
cause the cursor library to fail to load. If the cursor library fails to load,
the recordset will be a forward-only, read-only recordset. The following message
may appear in the trace output when this condition exists:

   Cursor library not used. Version mismatch with driver manager
   State:01000[Microsoft][ODBC DLL]

In some older versions of ODBC.DLL, this message may not appear even if the
Driver Manager and Cursor Library do not match.

MORE INFORMATION
================

To ensure that the Driver Manager and Cursor Library have the same cursor
level:

1. Open File Manager and go to the \WINDOWS\SYSTEM subdirectory.

2. Highlight the file ODBC.DLL (or ODBC32.DLL) and press ALT+ENTER or choose
   Properties from the File menu.

3. In the Version Information section of the dialog box that appears, select
   cursor level and note the level indicated.

4. Follow steps 1 through 3 for the ODBCCURS.DLL (or ODBCCR32.DLL) file. If the
   cursor levels are not the same, the Driver Manager and Cursor Library do not
   match.

What to Do If the Driver Manager and Cursor Library Do Not Match
----------------------------------------------------------------

If the Driver Manager and the Cursor Library do not match, reinstall the latest
version of Microsoft Data Access Components (MDAC) from the following Microsoft
Web site:

   http://www.microsoft.com/data

If the cursor level for the Driver Manager and Cursor Library do match, but the
trace message listed above still appears in the output, check to ensure that an
older version of the DLL's are not anywhere in the path of the program. You can
also use Component Checker Utility to verify MDAC installation. For additional
information on Component Checker, click the article number below to view the
article in the Microsoft Knowledge Base:

   Q307255 INFO: Component Checker: Diagnose Problems and Reconfigure MDAC
   Installations

Additional query words: 2.50 2.51 2.52 3.00 3.10 3.50

======================================================================
Keywords          : kbenv kbDatabase kbMFC kbODBC kbVC kbGrpDSVCDB kbGrpDSMDAC kbDSupport kbMDAC200 kbMDAC150 kbMDAC210 kbMDAC250 kbMDAC260 kbmdac270 
Technology        : kbAudDeveloper kbMFC
Version           : :1.5,1.51,1.52,2.0,2.1,2.2,2.5,2.6,4.1,4.2,5.0,6.0
Issue type        : kbhowto

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

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.

Copyright Microsoft Corporation 2001.