ACC97: SETUP: Microsoft Access 97 Does Not Install INSTCAT.SQL

Last reviewed: April 21, 1997
Article ID: Q162373

The information in this article applies to:

Microsoft Access 97

SYMPTOMS

Moderate: Requires basic macro, coding, and interoperability skills.

The Setup program for Microsoft Access 97 and Microsoft Office 97, Professional Edition does not install the SQL Script file, INSTCAT.SQL, to your hard disk. This file is used with the SQL Server ODBC driver to create stored procedures for use with versions of SQL Server earlier than version 6.5.

CAUSE

The functionality provided in the Instcat.sql file is integrated into SQL Server version 6.5 and later.

RESOLUTION

If you are running a version of Microsoft SQL Server earlier than version 6.5, and you plan to use the SQL Server Driver included on the Microsoft Office 97, Professional Edition or Microsoft Access 97 compact disc, you must copy the Instcat.sql file from the compact disc, so that it is available for your application. The file is stored on the compact disc in the \OS\System folder.

MORE INFORMATION

To properly configure versions of SQL Server earlier than SQL Server 6.5 for use with Microsoft ODBC, you must run the SQL script file INSTCAT.SQL to set up the proper stored procedures that provide catalog information used by Microsoft ODBC.

The INSTCAT.SQL script, when run on SQL Server, installs several stored procedures that are later used by the ODBC SQL Server driver to query the system catalog. Microsoft Access uses the SQL Server driver for ODBC access to SQL Server.

REFERENCES

For more information about the Instcat.sql file, search for the keyword "Instcat.sql" in the Microsoft SQL Server Books Online.

For more information about using the Instcat.sql file, please see the following articles in the Microsoft Knowledge Base:

   ARTICLE-ID: Q100467
   TITLE     : ACC: How To Determine Version of INSTCAT.SQL File on Server

   ARTICLE-ID: Q95061
   TITLE     : ACC: "Stored Procedure 'PROCEDURE' Not Found" Error Message

Keywords : kbsetup
Version : 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

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