Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/100467

From BetaArchive Wiki
Knowledge Base

ACC: How to Determine Version of INSTCAT.SQL File on Server

Article ID: 100467

Article Last Modified on 1/18/2007


  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition

This article was previously published under Q100467


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

Using the SQL Server ODBC driver with Microsoft Access requires that you run the INSTCAT.SQL file on the ODBC installation disks. This article describes the SQL stored procedure that you can use to query for the version number of the INSTCAT.SQL file that was run against the SQL Server computer.


The following syntax can be executed in a pass-through query in Microsoft Access 2.0, 7.0 and 97 as well as in the Query window of SQL Server Administration Facility (SAF) for MS-DOS, OS/2, Microsoft Windows or any other operating system in which you can execute a stored procedure:

   sp_server_info 500

The attribute_value field of the returned row contains the version number. If an empty recordset is returned, it is likely that the INSTCAT.SQL file was not run on the server. The result will resemble the following:

   attribute_id   attribute_name      attribute_value
   500            SYS_SPROC_VERSION   01.00.2101

OS/2 is manufactured by International Business Machines Corporation, a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Keywords: kb3rdparty kbhowto KB100467