Microsoft KB Archive/116275

{|
 * width="100%"|

-

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  /S  /i A:\INSTCAT.SQL where  is the system administrator's password, and  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.