Microsoft KB Archive/112482

{|
 * width="100%"|

-

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       :
 * }