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

ID: Q116269

The information in this article applies to:

Microsoft SQL Server for OS/2, version 4.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:

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

Execute DBNMPIPE from the \SQL\BIN directory

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
  
```

To make local named pipe connectivity (with or without networking software):

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
  
```

Execute DBNMPIPE from the \SQL\BIN directory.

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
  
```


Keywords          : kbtool SSrvServer 
Version           : 4.2 4.21 4.2b
Platform          : OS/2 
Issue type        :

Last Reviewed: March 19, 1999