SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

spdssnet

nnnn/tcp

not required

not required

spdssnet=name

nnnn=port number

assigned to server

protocol is always /tcp

Remember: The service name, spdssnet must match the server name that you used in step
6 of 

. The port number

must match the port number on which the SPD SNET server is running.

The following instructions create a query using Microsoft Access.

1. Start the SPD SNET server.

2. Start Microsoft Access.

3. From the Microsoft Access main menu, select File  

ð

 Get External Table .

4. Select Link Table.

5. Select Files of Type.

6. Select ODBC Databases.

7. Select the data source.

Read this information if you do not have Base SAS software on the network client, but you
want to use the power of the Java programming language to query SPD Server tables from
any client on the network that has a browser. You must have SPD Server tables on the
network and SPD Server and SPD SNET servers running on the same server as the Web
server in order to use JDBC to access SPD Server tables.

You might want to use JDBC if you have SPD Server tables available on your network and
one or more of the following is true:

•

You do not have Base SAS software on the network client to process the data sets.

•

You want to distribute the information across your corporate intranet through a Web
page.

•

The clients on your network are varied: UNIX boxes, Windows PCs, and workstations.
One thing they might have in common is browser access to your intranet.