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:
-
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.
-
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.
-
ODBC drivers only: ODBC
client applications require you to install the spds.dll application
extension. To install the ODBC client application extension:
-
Install the SAS 9.3
ODBC driver.
-
Copy the
InstallDir\lib\spds.dll
directory to the
<drive letter>:\Program
Files\sas\shared files\general
directory.
-
Configure an ODBC data
source for direct SPD Server access.