SAS does not support using SAS/ACCESS Interface to ODBC with such old versions of the unixODBC driver manager. However, often it is typically a very old version such as Version 2.2.14. Some UNIX environments-particularly Linux-often already have a unixODBC driver manager in place in a global location such as /usr/lib or /usr/lib64. When you use SAS/ACCESS Interface to ODBC with a unixODBC driver manager, you must use a current version (2.3.2 or later). See the unixODBC project home page to get the most current version of the unixODBC driver manager. A unixODBC driver manager works with most nonproprietary UNIX ODBC drivers. When you use DBMS vendor-provided or freeware ODBC drivers, you typically pair them with a freeware unixODBC driver manager.
SETUP INFORMIX ODBC DRIVERS
You must therefore find a single ODBC driver manager that works with all ODBC drivers for the ODBC data sources to which you need to connect when using SAS/ACCESS Interface to ODBC. In a single SAS session on UNIX platforms, SAS can use only a single ODBC driver. In this case, you provide all connection specifics for the database in your SAS/ACCESS Interface to ODBC code, instead of relying on INI files for this information.
SETUP INFORMIX ODBC CODE
INI files in users' home directories.Īfter the ODBC driver manager finds the designated INI files, it references the stanza for the data source name (DSN) that you have specified in your SAS/ACCESS Interface to ODBC code to obtain connection specifics for the particular database to which you want to connect-for example, the ODBC driver to use, the server where the database resides, the port, and the database name. The ODBC driver manager references one or more INI files that are specified in the UNIX environment variables-such as ODBCINI, ODBCINST, ODBCSYSINI-or, by default, it can reference one or more. Depending on your particular ODBC client configuration, the ODBC driver manager references either an ODBC.INI file or a combination of ODBC.INI and ODBCINST.INI files. SAS attempts to use the first 64-bit ODBC driver manager that it finds. SAS finds the ODBC driver manager by searching the directories that are specified in your particular environment variable settings on each UNIX platform. ODBC driver managers always have these names, no matter who provides the driver. SAS first looks for an ODBC driver manager when you submit SAS/ACCESS Interface to ODBC code on UNIX platforms. For details about what constitutes an ODBC-compliant driver on UNIX, see "Key Considerations When Using ODBC Drivers and SAS on UNIX" in the ODBC section of SAS/ACCESS Relational Databases: Reference. The ODBC drivers that you use with SAS/ACCESS Interface to ODBC must be compliant with the ODBC 3.5 or later specification. ODBC-compliant drivers for the ODBC data sources to which you need to connect.an ODBC driver manager: If you use a unixODBC driver manager, SAS requires a current version (2.3.2 or later).SAS/ACCESS Interface to ODBC on UNIX platforms requires these client components. See Using SAS/ACCESS Interface to ODBC on UNIX Platforms for a listing of all articles in this series. Read this one before continuing with any other articles.