20751-12 Rev.5 A-3
DataDirect Driver Manager
Place hidden configuration files in each user’s home directory if each user needs to access
different Netezza appliance data sources. Place non-hidden configuration files in the
/usr/local/etc directory if all users will access the same Netezza appliance data
sources.
With the unixODBC driver manager, you do not need to use the
NZ_ODBC_INI_PATH environment variable.
DataDirect Driver Manager
This section describes how the DataDirect driver manager searches for the ODBC configura-
tion files and how the DataDirect driver manager interacts with the Netezza ODBC drivers.
DataDirect Driver Manager Search Behavior
The default behavior of the DataDirect driver manager is to search the following two places,
in sequence, to locate the two ODBC configuration files:
1. The driver manager looks first in the current user’s home directory for the two non-hid-
den files odbcinst.ini and odbc.ini. If the two files exist as hidden files in the
user’s home directory, the driver manager ignores them.
2. If the driver manager does not find non-hidden configuration files in the user’s home
directory, it looks next in the /etc directory for the two non-hidden files
odbcinst.ini and odbc.ini. If the two configuration files exist as hidden files in
the /etc directory, the driver manager ignores them.
Incompatibilities
The following are incompatibilities between the Netezza ODBC drivers and the DataDirect
driver manager:
1. The DataDirect driver manager looks first in the current user’s home directory for non-
hidden configuration files instead of hidden ones.
2. The DataDirect driver manager looks next in the /etc directory instead of in the
/usr/local/etc directory.
3. The DataDirect driver manager also looks at the value of the environment variable
ODBCINI to determine the location of the odbc.ini file to use.
To work around the DataDirect driver manager’s ODBC configuration file search incompati-
bilities, do one of the following:
1. Separate Configuration Files in Each Home Directory. Use this method if you would like
each user of the Linux/UNIX client system to use a separate set of ODBC configuration
files. Netezza ODBC drivers look for hidden configuration files, and the DataDirect
driver manager looks for non-hidden files. To overcome this incompatibility, create two
soft links in each user’s home directory so the DataDirect driver manager finds non-hid-
den files in the home directory and the Netezza ODBC driver finds hidden files:
A soft link so odbcinst.ini points to .odbcinst.ini
A soft link so odbc.ini points to .odbc.ini
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji