Table 9.1 How to Add Service Name and Port Number to the Services File
column1
<service name>
column2
<port number & protocol>
column3
<aliases>
column4
<comment>
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 “Configuring an ODBC Data Source for SPD SNET” on page 98. The port number
must match the port number on which the SPD SNET server is running.
Creating a Query Using an ODBC-Compliant Program
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.
Using JDBC (Java) to Access SPD Server Tables
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.
Why Would I Want to Use JDBC?
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.
Why Would I Want to Use JDBC? 99
