Connecting to Common Data Sources

Troubleshooting SAS/ACCESS Connections to RDBMS

This section provides information about troubleshooting a SAS/ACCESS library configuration when registering tables fails. To troubleshoot the SAS/ACCESS library, perform the following steps:

From SAS Management Console, right-click the library icon and select Display LIBNAME Statement.
Start SAS on the SAS server host and issue the LIBNAME statement displayed from SAS Management Console.
1. If the SAS log indicates failure, check the following items:
  1. If this is UNIX environment, check Setting UNIX Environment Variables for SAS/ACCESS.
  2. Check and revise the LIBNAME statement. For more information about LIBNAME statements for SAS/ACCESS engines, see SAS/ACCESS for Relational Databases: Reference. If you are successful at this stage, then use the Properties tab of the library to reconfigure the library.
  3. Confirm that SAS/ACCESS is installed correctly. For installation information, go to the Install Center at http://support.sas.com/documentation/installcenter/92/documents/index.html and use the operating system and SAS version to locate the appropriate SAS Foundation Configuration Guide.
2. If the connection succeeds, perform the following steps:
  1. Run the DATASETS procedure:
```
proc datasets library = libref;
quit;
```
  2. If no members are returned, then check the schema value by running the next step or contacting your database administrator.
Log on with the user account to the host where the SAS server is running, and use the native database client to connect to the database. If this fails, confirm the user account has file system privileges to the database client binaries and libraries.

Top of Page