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

Last reviewed: April 29, 1997
Article ID: Q116269

The information in this article applies to:

  - 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
    

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

  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
    


Additional query words:
Keywords : kbtool SSrvServer
Version : 4.2 4.21 4.2b
Platform : OS/2


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.