ODBC Client Error After Connecting Using MDAC SQL Server Driver

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

Last Reviewed: January 19, 1998