SAS Safety Scalable Performance Data Server 4.5 사용자 설명서

10. Use SQL Pass-Through syntax rules for libref statements when you enter a value in the

Options text field.

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 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 

.

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 

4. Add an entry to the Services file, on its own line, in proper numeric order, using the

following syntax: