Chapter Contents


SAS ODBC Driver User's Guide and Programmer's Reference

Defining Servers

The SAS ODBC driver uses a SAS server to access your data sources. To access local data, the driver uses a SAS ODBC server. To access remote data, it uses a SAS/SHARE server. (See SAS Servers for more information.)

This section explains how to provide the SAS ODBC driver with necessary information about the server(s) you will be using.

  1. Select the Servers tab in the SAS ODBC Driver Configuration dialog to go to the Servers page. Supply the information described in the following steps. If at any time you want to clear all of the fields on the right side of the dialog and start again, select [Clear].

    Servers Page


  2. In the Name field, enter a name for the SAS server that you are defining. If you supply a one-part name such as shr1, the SAS ODBC driver infers that the server is local. If you supply a two-part name such as machine.shr2, the driver infers that the server is remote.

  3. If user access to the server is password protected, then enter the password in the Password field. This should be the same password that was specified for the UAPW= option in PROC SERVER (for a SAS/SHARE server), or in PROC ODBCSERV (for a local access server).

  4. If the server is a SAS ODBC server (used to access local data sources), then Local (Single User) is displayed in the SAS Server Type field. If the server is a SAS/SHARE server (used by multiple users), SAS/SHARE (Multi-User) is displayed.

  5. Select [Configure]. A configuration dialog appears.

  6. When you have finished making any necessary changes to the Local Options or SAS/SHARE Options dialogs, select [OK] to return to the Servers page (Servers Page).

  7. Important! Select [<<Add<<] to save your server definition. The server name now appears in the list of defined servers at the left.

  8. To define another server, select [Clear] and then repeat steps 2-8.

Deleting a Server Definition

To delete a previously defined server, do the following:

  1. Select the server name from the Servers list at the left of the Servers page.

  2. Select [>>Remove>>].
    If you delete a server, then any data sources that use that server will no longer be accessible until you redefine that server.   [cautionend]

Modifying a Server Definition
To change the information for a previously defined server, do the following:

  1. Select the server name from the Servers list at the left of the Servers page.

  2. Make the desired changes to the Password field. Select [Configure] to make changes in the Local Options or SAS/SHARE Options dialogs (Local Options Dialog and SAS/SHARE Options Dialog).

    The Name field is greyed out to indicate that you cannot change the name of the server. The reason for this is that you may have already defined data sources that use that server; if you changed the server name, then you would no longer be able to access those data sources.

  3. Select [<<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.

FOOTNOTE 1:  !SASROOT is a logical name for the directory in which you install the SAS System. For more information, see the SAS documentation for the Microsoft Windows or Microsoft Windows NT operating environment. [arrow]

Chapter Contents



Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.