PRB: "S1000 Connection Failed" with Connectivity Kit

ID: Q116275

The information in this article applies to:

Microsoft FoxPro for Windows, versions 2.5x, 2.6x
Microsoft FoxPro Connectivity Kit, versions 2.5x, 2.6x

SYMPTOMS

When you are trying to connect to a SQL Server machine using the Connectivity Kit's DBConnect() function, the following error message appears:

S1000 Connection failed [Microsoft][ODBC SQL Server driver]Unable to load Communication module. Driver has not been correctly installed.

CAUSE

This error may be caused by one of the following situations:

SQL Server has been configured to used named pipes instead of SPX/IPX or vice versa.

The required set of stored procedures required for ODBC to work have not been installed on the SQL Server machine.

RESOLUTION

To change SQL Server's configuration from named pipes to SPX/IPX or vice versa, see the SQL Server documentation or contact Microsoft SQL Server Product Support Services, or the following Knowledge Base article:

Q137635 INF: ODBC SQL Server Connection Parameters

The SQL Server driver uses a set of system stored procedures, known as the catalog stored procedures, to obtain information from the SQL Server system catalog. If the version of the Microsoft SQL Server ODBC driver you are using is newer than the SQL Server to which you are connecting, you will need to have the SQL Server system administrator upgrade the catalog stored procedures.

For more information about determining if the stored procedures need to be upgraded, and instructions for doing the upgrade, please see the following article in the Microsoft Knowledge Base:

Q137636 INF: Relationship of the ODBC Driver to INSTCAT.SQL

To install the catalog stored procedures:

Insert the disk the SQL Server driver was shipped on in drive A.

Run the INSTCAT.SQL batch file in the isql utility. For example
```
      C:> ISQL /U sa /P <sa-password> /S <server-name> /i A:\INSTCAT.SQL 
```
where <sa-password> is the system administrator's password, and <server- name> is the name of the server on which SQL Server resides.

NOTE: To run isql, your computer must be installed as a client workstation for SQL Server. If you are using a version of SQL Server earlier than 4.2a, you must install the system stored procedures (catalog procedures) by running the INSTCAT.SQL file, which is a batch file in the isql utility on SQL Server.

REFERENCES

The instructions on how to install the catalog procedures come directly from the Help file that comes with the SQL Server driver. For more information, see the "Installing the Catalog Stored Procedures" topic in the Help file that comes with the SQL Server driver.

Additional query words: FoxWin 2.50 2.50a 2.50b 2.60 2.60a CK errmsg


Keywords          : 
Version           : 
Platform          : 
Issue type        :