Microsoft KB Archive/162373

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

Article ID: 162373

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q162373



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



SYMPTOMS
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.

