> # Configuring ODBC Client Data Sources on Linux and UNIX

> For Linux and UNIX, an ODBC Administrator does not exist. This section describes how to configure the system information file and how to set some required environment variables to use the ODBC 32-bit Client and ODBC 64-bit Client on Linux and UNIX.

> ### Configuring the System Information File

> To configure an ODBC data source for Linux and UNIX, you must edit the odbc.ini file (32-bit Client) or odbc64.ini file (64-bit Client) using the attributes in Table 1-1 "ODBC Connection Attributes". In the following examples, notice that the description is the same for the 32-bit and 64-bit ODBC Client.

> ### Example: odbc.ini for Solaris

> The following code shows an example of an odbc.ini file for a 32-bit ODBC Client installed on a Solaris machine:

>     [ODBC Data Sources]
>     SALESDB=DataDirect SequeLink 6.0
>     [SALESDB]
>     Driver=path_of_installdir/lib/ivslk22.so
>     Description=DataDirect SequeLink 6.0
>     Host=
>     Port=
>     UseLDAP=0
>     DistinguishedName=
>     Encrypted=0
>     LoadBalancing=0
>     AlternateServers=
>     ConnectionRetryCount=0
>     ConnectionRetryDelay=3
>     [ODBC]
>     Trace=0
>     IANAAppCodePage=4
>     TraceFile=odbctrace.out
>     TraceDll=path_of_installdir/lib/odbctrac.so
>     InstallDir=path_of_installdir

> where `path_of_installdir` is the path to the ODBC Client installation directory.

> ### Example: odbc64.ini for Solaris

> The following code shows an example of the odbc64.ini file for a 64-bit ODBC Client installed on a Solaris machine:

>     [ODBC Data Sources]
>     SALESDB=DataDirect SequeLink 6.0
>     [AccountingDB]
>     Driver=path_of_installdir/lib64/ivslk22.so
>     Description=DataDirect SequeLink 6.0
>     Host=
>     Port=
>     UseLDAP=0
>     DistinguishedName=
>     Encrypted=0
>     LoadBalancing=0
>     AlternateServers=
>     ConnectionRetryCount=0
>     ConnectionRetryDelay=3
>     [ODBC]
>     Trace=0
>     IANAAppCodePage=4
>     TraceFile=odbctrace.out
>     TraceDll=path_of_installdir/lib64/odbctrac.so
>     InstallDir=path_of_installdir

> where `path_of_installdir` is the path to the ODBC Client installation directory.

> ### Setting Environment Variables

> You must set several environment variables for the ODBC Client on Linux and UNIX by executing a shell script located in the installation directory.

> To execute the shell script:

> - If you are using the Bourne or Korn shell, type:
> - `. sqlnk.sh` (32-bit client)
> - `. sqlnk64.sh` (64-bit client)
> - If you are using the C shell, type:
> - `source sqlnk.csh` (32-bit client)
> - `source sqlnk64.csh` (64-bit client)

> Executing this shell script sets the following environment variables:

> ODBCINI | Specifies where the centralized odbc.ini or odbc64.ini file is located.
> SQLNK_ODBC_HOME | Specifies the full path of the directory containing the ODBC Client shared libraries.

> Executing this shell script also sets the appropriate library search environment variable (LD_LIBRARY_PATH on Solaris and Linux, SHLIB_PATH on HP-UX, or LIBPATH on AIX).

> ### Using a Centralized System Information File

> Because Linux and UNIX are multi-user environments, you may want to use a single centralized odbc.ini file controlled by a system administrator. To do this, set the ODBCINI environment variable to point to the fully qualified pathname of the centralized file.

> For example:

> - In the Bourne or Korn shell, type:

> ODBCINI=/opt/odbc/system_odbc.ini;export ODBCINI

> - In the C shell, type:

> setenv ODBCINI /opt/odbc/system_odbc.ini

> The odbc.ini file also require an [ODBC] section that includes the InstallDir keyword. The value of the InstallDir keyword must be the path to the directory that contains the /lib and /messages directories.

> For example, if you choose the default installation directory for the 32-bit ODBC Client, the following line must be in the [ODBC] section of the odbc.ini file:

>     InstallDir=/usr/slodbc60