ODBC Driver for Microsoft Access

Build 23.0.8839

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:

  1. Set ODBCHOME env:
    >$ export ODBCHOME=/usr/local/SASHome/dfs/etc
  2. Set ODBCINI env:
    >$ export ODBCINI=$ODBCHOME/odbc.ini
  3. Set LD_LIBRARY_PATH env:
    >$ export LD_LIBRARY_PATH=/usr/local/SASHome/dfs/lib:$LD_LIBRARY_PATH
You can then follow the procedure in Using the DataDirect Driver Manager to set the driver encoding configure the DSN for SAS in the odbc.ini file. For example, in /usr/local/SASHome/dfs/etc/odbc.ini.

Note: The step to register the driver in odbcinst.ini is not required for SAS.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839