ODBC Client Error After Connecting Using MDAC SQL Server Driver

Last reviewed: January 19, 1998
Article ID: Q178132
The information in this article applies to:
  • Microsoft Data Access Components, version 1.5
  • Microsoft SQL Server, version 6.5

SYMPTOMS

After installing the Microsoft Data Access Components (MDAC) SQL Server Driver, the ODBC Client receives the following error message after successfully connecting:

   The ODBC catalog stored procedures installed on server
   MySQLServerName are version 6.50.193; version 07.00.0324 or
   later is required to ensure proper operation. Please contact
   your system administrator.

WORKAROUND

To workaround this problem, the SQL Server Driver, Sqlsrv32.dll, installed by the MDAC Setup program must be replaced with Sqlsrv32.dll version 3.50.0305. Also, the SQL Server administrator needs to run the Instcat.sql script.

The following file is available for download from the Microsoft Software Library:

 ~ mdacsql.exe (size: 261251 bytes) 

For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q119591
   TITLE     : How to Obtain Microsoft Support Files from Online Services

The files in the Microsoft Software Library (MSL) are compressed, self- extracting executables. After you download the file you need, simply run it to extract the files it contains. Note that the expanded file contains the following files:
  • Sqlsrv32.dll
  • Instcat.sql
  • Readme.txt

To replace the driver on Windows NT

  1. Shut down any applications currently using ODBC.

  2. Copy Sqlsrv32.dll to the \Winnt\System32 folder.

To replace the driver on Windows 95

  1. Shut down any applications currently using ODBC.

  2. Copy Sqlsrv32.dll to the \Windows\System folder.

Running Instcat.sql script

To run the Instcat.sql script, use the command line ISQL utility, which is documented in the SQL Server "Transact-SQL Reference" manual:

   cd \<default sql directory>\install
   isql /Usa /Ppassword /Sservername /iinstcat.sql /oinstcat.rpt

STATUS

Microsoft has confirmed this to be a problem in the SQL Server Driver included in the Microsoft Data Access Components. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

For additional information about the relationship of the ODBC driver to Instcat.sql, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q137636
   TITLE     : INF: Relationship of the ODBC Driver to INSTCAT.SQL


Additional query words: open database connectivity instcat

Technology : mdac odbc
Platform : winnt
Solution Type : kbfile


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