ACC2000: Microsoft Access 2000 Does Not Install INSTCAT.SQL (208740)
The information in this article applies to:
This article was previously published under Q208740 Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
The Setup program for Microsoft Access 2000 and Microsoft Office 2000,
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 Server version 6.5.
CAUSE
The functionality provided in the INSTCAT.SQL file is integrated into SQL
Server version 7.0, but not in SQL Server version 6.5.
RESOLUTION
If you are running SQL Server version 6.5, and you plan to use the SQL Server driver included on the Access or Office 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 \System folder.
MORE INFORMATION
To properly configure 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 6.5, 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. To obtain the SQL Server 7.0 Books Online, please visit the following Microsoft Web site:
For additional information about using the INSTCAT.SQL file, please see the following article in the Microsoft Knowledge Base:
209523 How to Determine Version of INSTCAT.SQL File on Server
| Modification Type: | Minor | Last Reviewed: | 8/9/2004 |
|---|
| Keywords: | kbdownload kbprb kbsetup KB208740 |
|---|
|