SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 103 / 271

Primary and Secondary LIBNAME Domains
When a connection to the SPD server is established a primary LIBNAME domain is
assigned. The primary LIBNAME domain is specified by the "DBQ" connection options
parameter. Immediately after the connection is made the SAS ODBC Driver assigns the
secondary LIBNAME domains which are configured through the Libraries tab of the SAS
ODBC Driver Configuration window.
ODBC Connections via the SPD SNET server must have an odbc.parm file configured
on the SPD SNET Server machine.
Configuring an ODBC Data Source to Connect Directly to an SPD
Server
Once the SAS ODBC driver is installed, you will need to configure your ODBC data source.
When you open the ODBC manager, you'll get a display screen that allows you to enter
information that points the OBDC driver to the data on the SPD Server.
1. From the Windows Start button, select Start
ð
Settings
ð
Control Panel
2. Locate the ODBC Data Sources icon and open the Microsoft ODBC Data Source
Administrator . The exact location of this program depends on your version of
Windows.
3. Select the Add button, then select the SAS ODBC driver.
4. Enter a data source name (and description if desired.)
5. Select the Servers panel and type in your two-part server name.
6. Click on the Configure box. The TCP Options window appears:
• Server Address: Enter the network address of the machine on which the SPD
Server is running.
• Server User Name: Enter the user name as configured for a DBQ (SPD Server
primary LIBNAME domain) on the SPD Server to which you will connect.
• Server User Password: Enter the user password as configured for a DBQ (SPD
Server primary LIBNAME domain) on the SPD Server host to which you will
connect.
• Connection Options: Enter the Connection Options as follows:
• DBQ='SPD Server primary LIBNAME domain', this is the SPD Server
LIBNAME domain
• HOST='name server node name', this is the location of the host computer
• SERV='name server port number', this is the port number of the SPD Server
name server running on the HOST.
• Any other SPD Server LIBNAME options. For more information, see the User's
Guide section on LIBNAME Options.
7. Click OK. Then, click Add, and select the Libraries panel.
8. Enter the DBQ name of a secondary LIBNAME domain in both the Name and Host
File text fields.
9. Enter "spdseng" in the Engine text field.
Configuring an ODBC Data Source to Connect Directly to an SPD Server
97