Install and Configure SPD Server Clients

SPD Server client software makes SAS LIBNAME connections and performs user-specific functions on the SPD Server host. SPD Server client software is installed with SAS 9.3. The software contains the following SAS modules:
  • sasspds is the LIBNAME engine that is required to access the SPD Server environment from SAS 9.3.
  • sasspdo is the SPD Server operator procedure that is required to access the SPD Server 4.5 environment from SAS 9.3.
  • spds.msg is the message file for the SPD Server LIBNAME engine and SPDO operator procedure. This file is compatible with SAS.
You install the SPD Server client software with SAS 9.3 Foundation at <SASROOT>\SASFoundation\9.3\spdclient. The SAS 9.3 configuration file automatically includes your SPD Server client software directory in its required path list.
After you have configured the SPD Server environment and SPD Server is running, you need to complete other installation tasks on the SAS clients that will use SPD Server. Because some of these tasks might involve the system that is actually running SPD Server, you might have already completed some of the following steps when you installed the SPD Server host. If that is the case, skip the duplicated steps.
SPD Server media contains SAS client software modules for SAS 9.3 installations on Solaris by Sun, AIX by IBM, and HP-UX by Hewlett-Packard. Complete the following steps on each SAS client that will access SPD Server:
  1. If you want to access SPD Server through a registered port (name service), add the following service to your client's \etc\services file (if this file is not already present):
    spdsname ????\tcp # SPDS Name service
    This service defines the port number for the SPD Server name server process (spdsnsrv). Make sure that this port number matches the port number you used when you installed SPD Server. If you are running SAS on an existing SPD Server installation, this service name is probably already defined. You can either define another service name for the SAS client to use (for example, sp45name), or you can directly include the SPD Server port number in your SAS statements.
  2. The SPD Server can be accessed with the SAS 9.3 ODBC Driver, JDBC Driver, and htmSQL Driver. Download these drivers from the Support tab at http://support.sas.com.
    For more information about connecting and configuring these applications, see Using SPD Server with Other Clients .
  3. ODBC drivers only: ODBC client applications require you to install the spds.dll application extension. To install the ODBC client application extension:
    1. Install the SAS 9.3 ODBC driver.
    2. Copy the InstallDir\lib\spds.dll directory to the <drive letter>:\Program Files\sas\shared files\general directory.
    3. Configure an ODBC data source for direct SPD Server access.