From SAS
This section describes how to create a DSN for use with SAS running on a Linux machine.
Configure a DSN
Before defining the DSN, complete the following the prerequisite steps:
- Set ODBCHOME env:
>$ export ODBCHOME=/usr/local/SASHome/dfs/etc
- Set ODBCINI env:
>$ export ODBCINI=$ODBCHOME/odbc.ini
- Set LD_LIBRARY_PATH env:
>$ export LD_LIBRARY_PATH=/usr/local/SASHome/dfs/lib:$LD_LIBRARY_PATH
Note: The step to register the driver in odbcinst.ini is not required for SAS.