Using the Servers Tab

Purpose of the Servers Tab

The Servers tab of the SAS ODBC Driver Configuration dialog box is used for adding, deleting, and modifying server definitions. The SAS ODBC Driver can communicate with a SAS ODBC server for local data access, or with a SAS/SHARE server and an SPD Server for remote data access. This tab has the following fields:
Name
identifies the SAS server name of the data source. This value can be a one-part name, such as local, or a two-part name, such as machine.shr2. Use a one-part name when you want to access local data or a two-part name when you want to access remote data.
Password
identifies the password that the SAS ODBC Driver sends to a password-protected SAS/SHARE server.
Configure
opens the Local Options dialog box or the SAS/SHARE Options dialog box.
SAS Server Type
identifies whether the server is local or remote. For a server with a one-part name, this field says Local (Single User). For a server with a two-part name, this field says SAS/SHARE (Multi-User).
Clear
click this button to clear all of the fields in the Server Settings area.

Deleting a Server Definition

To delete a defined server, complete these steps:
  1. Select the server name from the Servers list on the Servers page.
  2. Click Remove.
    CAUTION:
    If you delete a server, then any data sources that use the server are no longer accessible until you redefine the server.

Modifying a Server Definition

To change the information for a defined server, complete these steps:
  1. Select the server name from the Servers list on the Servers page.
  2. To make changes, click Configure in the Local Options or SAS/SHARE Options dialog box.
    The Name field is disabled to indicate that you cannot change the name of the server. The reason is that you might have defined data sources that use that server. If you change the server name, then you can no longer access those data sources.
  3. Click Update to save your changes.
For instructions on how to specify a different server for a data source that you have already defined, see Specifying a Different Server for a Defined Data Source.