SAS/IntrNet 9.2: htmSQL

Configuring TCP/IP

htmSQL uses TCP/IP to communicate with a SAS/SHARE server. To enable communication between your Web server and a SAS/SHARE server through TCP/IP, you must perform the following configuration steps:

Specify one of the following options on the SAS command or in an OPTIONS statement when you start the SAS/SHARE SERVER procedure (PROC SERVER):
- COMAMID=TCP
- COMAUX1=TCP.
Define the SAS/SHARE server in the TCP/IP SERVICES file that is on the SAS/SHARE server machine and on the Web server machine.

Note: If you use a port number to identify a SAS/SHARE server, then you do not need to modify the SERVICES file on the Web server machine.
- For UNIX and z/OS, the SERVICES file is
```
/etc/services
```
- For Windows NT and Windows 2000, the SERVICES file is
```
%SYSTEMROOT%/system32/drivers/etc/SERVICES
```
  where %SYSTEMROOT% is the directory where Windows NT is installed.
Each entry in the SERVICES file associates a service name with the port number and communications protocol that are used by that service. For htmSQL, use the name of the SAS/SHARE server as the service name. An entry for a SAS/SHARE server has the form
```
<server-name>  <port number>/tcp  # <comments>
```
The server name must be 1-8 characters long and is generally case sensitive. The first character must be a letter or underscore; the remaining seven characters can include letters, digits, underscores, the dollar sign ($), or the at sign (@). You specify this same server name when you define the server for your data source (either in the data source definition file or in the server= parameter of the {query} or {update} directive).

Note: z/OS is the successor to the OS/390 and MVS operating systems. SAS/IntrNet 9.1 for z/OS is supported on the MVS, OS/390, and z/OS operating systems and, throughout this document, any reference to z/OS also applies to OS/390 and MVS, unless otherwise stated.

Top of Page