Setting Up a Connection to SPD Server

The SAS ODBC Driver uses a TCP/IP network connection and a SPD Server library–spds.dll–to communicate with the SPD Server. Contact your SPD Server administrator to get the spds.dll file from the lib directory in the SPD Server distribution. Then, place the spds.dll file in C:\Program Files\SAS\SharedFiles\General.

Use the instructions in this section to create a Data Source Name (DSN) for accessing data on an SPD Server.

Access the SAS ODBC Driver Configuration dialog box.
Click the Servers tab. In the Name field, provide a two-part name such as spdserver.5190. SAS/SHARE (Multi-User) appears in the SAS Server Type field even though this is a connection to an SPD Server.

The first part of the name is the host name of the SPD Server. The second part of the name is the port number of the SPD Server Name Server.
Do not enter a value in the Password field. This field is not used for connections to SPD Server.
Click Configure. The SAS/SHARE Options dialog box appears.

Provide the requested information:

Server Address

is automatically filled with the alias for the TCP/IP network machine name.

User Name

is your user ID for the SPD Server.

User Password

is your password on the SPD Server. If you provide a User Name without a User Password, then you are prompted for a password at connection time. The SAS ODBC Driver encrypts the password before storing the encrypted value in the Windows registry.

Connect Options

provide the DBQ, HOST, and SERV parameters for the SPD Server. For example, DBQ='acct' HOST='spdserver.example.com' SERV='5190'.

DBQ is the SPD Server LIBNAME domain.

HOST is the name of the machine that is hosting the SPD Server.

SERV is the port number of the SPD Server Name Server.

Userid/Password Override

requests that the UID keyword and PWD keyword be used in the ODBC client application. The driver passes the value of the PWD keyword as the user login password, and the value of the UID keyword as the user ID. For more information about using this option, see Userid/Password Override.
Click OK to return to the Servers tab.

Important! Click Add to save the server definition.
Click the Libraries tab. Define a library for each data library that you want to access with this DSN.

Note: Add a library for the DBQ= domain that you provided in the connect options. This library is called the primary LIBNAME domain. Also, add additional libraries that you want to access. These libraries are called secondary LIBNAME domains.

Name

enter the name of a LIBNAME domain that is defined on the SPD Server

Host File

enter the name of the LIBNAME domain again. This field is not used for a connection to SPD Server because the storage for the data is controlled by the SPD Server.

Description

provide a description of the library to remind yourself or other users what the library contains. Providing this value is optional.

Engine

enter spdseng.

Options

use the DBQ= option to identify the LIBNAME domain. For example, DBQ='acct'. Enclose the LIBNAME domain in single quotation marks.
Click Add to save your library information. The library name is added to the list of libraries on the left.
Click the General tab.
Provide a name in the Data Source Name field. Use the Server menu to select the correct server for the DSN. For more information about SQL options, see SQL Options on the General Tab.