INF: SQL Server and ODS Sample Gateway on One Machine

ID: Q89365

The information in this article applies to:

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

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.

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
Issue type :