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.