INF: SQL Server and ODS Sample Gateway on One Machine

Last reviewed: April 28, 1997
Article ID: Q89365

The information in this article applies to:
  • Microsoft SQL Server version 4.2 for OS/2

SUMMARY

By default, SQL Server listens on the default pipe \PIPE\SQL\QUERY. This article describes the method for using an alternate pipe to set up SQL Server and an Open Data Services (ODS) application (sample gateway) on a single machine. This can be achieved in two ways:

  • Starting SQL Server on an alternate pipe and making the ODS application listen to the default pipe.
  • Starting SQL Server to listen on the default pipe and starting the ODS application on an alternate pipe.

This article gives step-by-step instructions on how to set up the first option. The second option can be set up similarly. The DB-Library (DB-Lib) clients, by default, communicate through default pipes. In either case, the client sides might need to be modified, by making appropriate entries in the AUTOEXEC.BAT file (MS-DOS), the WIN.INI file (Windows), and the OS2.INI file (OS/2) in order to communicate through alternate pipes.

Let the machine, where both SQL Server and the sample gateway are going to run, be called \\GEORGE. Then on this machine:

  1. Start SQL Server on an alternate pipe, say newpipe, by executing the following:

          sqlservr -dc:\sql\data\master.dat -pnewpipe
    

    On a LAN Manager network, you can start SQL Server on an alternate pipe, as a network service. This is documented in the READ.ME file in the OPENDS directory and is done by making the following entry in the LANMAN.INI file:

          [sqlserver]
    
             database = c:\sql\data\master.dat
             errorlog = c:\sql\log\errorlog
             executable = c:\sql\binp\sqlservr.exe
             -pnewpipe
    
       These commands will start SQL Server, listening on the pipe
       \PIPE\NEWPIPE\QUERY.
    
    

  2. Start the sample gateway program in a different screen group

          gateway -Snewserv
    

    where "newserv" is a logical name and corresponds to the following entry in the OS2.INI file on \\GEORGE:

          App: SQLSERVER
          Key: newserv
          Value: dbnmpp,\pipe\newpipe\query
    

    This entry can be made using the INIEDIT.EXE or WRITEINI.EXE utilities that come with the Open Data Services. By default, when clients connect to \\GEORGE, they will connect to the sample gateway application, which in turn has a connection to SQL Server on the same machine, through the pipe \PIPE\NEWPIPE\QUERY.


Additional query words: DB_Library db-lib
Keywords : kbprg SSrvODS SSrvProg
Version : 4.2
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 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.