SAS Scalable Performance Data Server 4.5, Administrator'S Manual

Page: 104 / 271

10. Use SQL Pass-Through syntax rules for libref statements when you enter a value in the
Options text field.
Configuring an ODBC Data Source for SPD SNET
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. Click on the ODBC icon and select the Add button.
3. Select the SAS ODBC driver.
4. Enter a data source name (and description if desired).
5. Select the Servers panel and type in the two-part server name. The second part of the
server name should match the entry in the services file. In the example that follows that
shows you how to edit the services file, the server name is
spdssnet .
6. Click on the Configure box. The TCP Options window appears with four input fields
that you fill:
• Server Address: Enter the network address of the machine on which the SPD
SNET 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.
7. Click OK, and then click Add.
Editing the Services File on Your Machine - ODBC Details
Editing the Services file is required only for ODBC connections via the SPD SNET Server.
1. Find the Services file on your Windows machine. In Windows, the Services file is
usually located in
c:\windows\services
.
2. Open the Services file using a text editor.
3. The services file contains four columns. The rows of information can be sorted in port
number order. Find the closest port number to the SPD Server port number, which you
obtained from the network administrator. See
“Preparing your Client Machine for
ODBC Installation” on page 96 ). This is where you insert the new information.
4. Add an entry to the Services file, on its own line, in proper numeric order, using the
following syntax:
98
Chapter 9 • Using SPD Server With Other Clients