How to Make an MS-DOS Level SQL Server Connection

ID: Q112482

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.5x, 2.6x

SUMMARY

The procedure below shows how to use the Connectivity Kit to connect to a SYBASE or Microsoft SQL Server from within FoxPro for MS-DOS.

MORE INFORMATION

NOTE: The FPSQL.PLB file supports only SQL Server connections. The file DBNMPIPE.EXE must be loaded before FoxPro for MS-DOS is started. the DBNMPIPE.EXE file is not supplied in the Connectivity Kit; it is provided with the SQL Server software.

To connect to a SQL Server machine, do the following:

Boot the machine and load the workstation software.

Load DBNMPIPE.EXE at the MS-DOS prompt.

Start FoxPro for MS-DOS.

Type the following lines in the Command window: SET LIBRARY TO SYS(2004)+"FPSQL" ADDITIVE handle=DBConnect("your_SQL_Server_name","sa","password","pubs")

Handle will return a positive number if you have a proper connection. "Your_SQL_Server_name" can be called anything. Check with your SQL administrator to find out its exact name. For more information, see page 5 of the FoxPro Connectivity Kit "User's Guide."

Additional query words: FoxDos 2.50 2.50a 2.50b 2.60 2.60a ODBC CK


Keywords          : 
Version           : 2.5x 2.6x
Platform          : MS-DOS 
Issue type        :