If you are attempting
to connect to data sources located on UNIX by using
SAS/ACCESS, you must set environmental variables
so that SAS servers can access the database. Each database vendor
and operating system vendor requires specific environment variables
to be set. A typical value is LD_LIBRARY_PATH. When using ODBC, two
typical values are ODBCINI and ODBCINSTINI. For more information about
the correct environment variables, go to the Install Center at
http://support.sas.com/documentation/installcenter/93, and use the operating system and SAS version to locate
the appropriate SAS Foundation Configuration Guide.
To set the appropriate
environment variables in the
!SASROOT/bin/sasenv_local file,
perform the following steps:
-
Edit the
sasenv_local file
and add the variables. This example uses sample values, substitute
the proper paths:
ODBCINI=/opt/Composite_Software/CIS_4.6.0/odbc.ini
export ODBCINI
ODBCINSTINI=/opt/Composite_Software/CIS_4.6.0/odbcinst.ini
export ODBCINSTINI
LD_LIBRARY_PATH=/opt/Composite_Software/CIS_4.6.0/apps/odbc/lib:\
/opt/oracle/app/oracle/product/11.1.0/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
ORACLE_HOME=/opt/oracle/app/oracle/product/11.1.0
export ORACLE_HOME
-
In SAS Management Console,
right-click the
Workspace Server connection
and select
Validate to verify that the workspace
server starts correctly with the new environment variables.
-
Restart the
SAS/SHARE
and
SAS/CONNECT servers, if they are present in the deployment and
reference the
SAS/ACCESS library.