ACC97: SETUP: Microsoft Access 97 Does Not Install INSTCAT.SQL (162373)
The information in this article applies to:
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.
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:
100467 ACC: How To Determine Version of INSTCAT.SQL File on Server
95061 ACC: "Stored Procedure 'PROCEDURE' Not Found" Error Message
| Modification Type: | Major | Last Reviewed: | 9/26/2003 |
|---|
| Keywords: | kbprb kbsetup KB162373 |
|---|
|