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 line 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 7 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).