Microsoft KB Archive/116269

{|
 * width="100%"|

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

 * }

Q116269

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

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 =\\ \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:

<pre class="CODESAMP">     ISQL /Stest /Usa /P </li></ol>

Additional query words:

Keywords : kbtool

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2