ACC1: INSTCAT.SQL File for MS Access 1.0 Available on MSL

Article ID: Q113552
Creation Date: 06-APR-1994
Revision Date: 24-APR-1997

The information in this article applies to:

Microsoft Access versions 1.0

SUMMARY

Advanced: Requires expert coding, interoperability, and multiuser skills.

The INSTCAT.SQL file, available on the Microsoft Software Library (MSL), contains updated ODBC stored procedures for Microsoft Access version 1.0. This file must be installed on a SQL Server before you can access data from that server.

MORE INFORMATION

 ~ SQL100.EXE (size: 41188 bytes) 
              is available for download from the Microsoft Software
   Library. It contains the following files:

   INSTCAT.SQL -  03-04-93
   INSTCAT.48  -  10-22-92
   README.TXT  -  06-14-93

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 INSTCAT.SQL file is the script file that creates catalog stored procedures on a Microsoft SQL Server or Sybase SQL Server versions prior to version 4.8.

Use the INSTCAT.48 file for versions of Sybase SQL Server 4.8 or higher.

If the INSTCAT.SQL script has not been properly installed, the following error message will be displayed when you try to attach an SQL table in Microsoft Access:

   [Microsoft][ODBC SQL Server Driver] The ODBC catalog stored
   procedures installed on your server <servername> are version
   xx.xxxx; version xx.xx.xxxx is required to ensure proper
   operation. Please contact your system administrator.

To install the catalog stored procedures, use the SQL Server ISQL (Interactive SQL) tool. You can run the ISQL tool from the MS-DOS or OS/2 command line.

NOTE: You cannot use the SAF utility to install INSTCAT.SQL. Microsoft SAF for MS-DOS and OS/2 is limited to 511 lines of code in an SQL script.

The syntax to install INSTCAT.SQL using ISQL is:

   isql /U <sa loginname> /n /P <password> /S <SQL servername>
   /i <drive:\path\INSTCAT.SQL> /o <drive:\path\outputfilename>

   NOTE: Enter the preceding two lines as one line at the command
   prompt, and do not include the angle brackets (< >).

   /U   Login name for the system administrator.

   /n   Eliminates line numbering and prompting for user input.

   /P   Password (case sensitive) used for the system administrator.

   /S   Name of the driver to set up.

   /i   Provides the drive and fully qualified path for INSTCAT.SQL.

   /o   Provides ISQL with an output file destination for results,
        including errors.

For example:

   isql /U sa /n /P skier /S DUMMY_SERVER /i D:\SQL\INSTCAT.SQL /o
   D:\SQL\OUTPUT.TXT

Keywords : kbfile Softlib
Version : 1.0
Platform : WINDOWS
Hardware : X86
Issue type : kbinfo

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.