INF: Named Pipes Connectivity in an OS/2 2.1 MS-DOS Box

  - Microsoft SQL Server version 4.2 for OS/2

SUMMARY

OS/2 version 2.1 allows named pipe connectivity in a MS-DOS compatibility box. This can be done over the network using networking software or locally on the server machine itself through the local pipes facilities built into the OS/2 2.1 MS-DOS box.

MORE INFORMATION

As mentioned above, OS/2 2.1 provides the ability to make named pipes connections through its MS-DOS compatibility box. There are two different named pipes connection types: local and network. The following items describe how to set up each of these named piped connection types:

To make Network named pipe connectivity:

1. Load the appropriate network and named pipes drivers needed to access the desired network.

2. Execute DBNMPIPE from the \SQL\BIN directory

3. Connect to the server using ISQL from the \SQL\BIN directory. For example, to connect to the network SQL Server TEST1 the ISQL command line would be similar to:

         ISQL /Stest1 /Usa /P
   

1. Set a DOS environment variable equal to the pipe that SQL Server listens on (default is \pipe\sql\query). The environment variable name must be the same as the local server name and must be in the format:

         SET <server name>=\\<server name>\pipe\sql\query
   

   For example, to connect to the local server TEST you would create the DOS environment variable as:

         SET test=\\test\pipe\sql\query
   

2. Execute DBNMPIPE from the \SQL\BIN directory.

3. Connect to the server using ISQL from the \SQL\BIN directory. For example, to connect to the local SQL Server TEST the ISQL command line would be similar to:

         ISQL /Stest /Usa /P