A-2 20751-12 Rev.5
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide
3. If the driver does not find hidden configuration files in the current user’s home direc-
tory, it next looks in the /usr/local/etc directory for the two non-hidden files
odbcinst.ini and odbc.ini. If the two configuration files exist as hidden files in
the /usr/local/etc directory, the driver ignores them.
ODBC Driver Considerations
Placing hidden configuration files in the user’s home directory is useful if each user of the
Linux/UNIX system has a separate set of configuration files, possibly describing different
Netezza appliance data sources. Each user’s home directory has a pair of hidden configura-
tion files describing the Netezza appliance data sources that user can access.
Placing non-hidden configuration files in either the first or third location is useful if you
want all users of the client system to have access to the same set of Netezza appliance data
sources, without requiring a separate set of configuration files in each user’s home direc-
tory. The
/usr/local/etc directory or the NZ_ODBC_INI_PATH directory contains a single set of
non-hidden configuration files describing the Netezza appliance data sources that all users
of the client system can access.
You can decide where to place the ODBC configuration files depending on how you are
using the client system.
The way in which the Netezza ODBC driver looks for ODBC configuration files is straightfor-
ward and unambiguous. However, the driver manager installed on the client system also
uses the two ODBC configuration files. The way in which a Netezza ODBC driver looks for
ODBC configuration files can sometime conflict with the way in which the driver manager
looks for them. This can sometimes cause configuration problems.
unixODBC Driver Manager
This section describes how the unixODBC driver manager searches for the ODBC configura-
tion files and how the unixODBC driver manager interacts with the Netezza ODBC drivers.
unixODBC Driver Manager Search Behavior
The default behavior of the unixODBC driver manager is to search the following 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 hidden
files: .odbcinst.ini and .odbc.ini. If the two configuration files exist as non-
hidden files in the user’s home directory, the driver manager ignores them.
2. If the driver manager does not find hidden configuration files in the user’s home direc-
tory, it looks next in the /usr/local/etc directory for the two non-hidden files
odbcinst.ini and odbc.ini. If the two configuration files exist as hidden files in
the /usr/local/etc directory, the driver manager ignores them.
Compatibility
The methods the Netezza ODBC driver and the unixODBC driver manager use to locate the
configuration files are compatible. It is relatively easy to ensure that the Netezza ODBC
Driver and the unixODBC driver manager find the two ODBC configuration files in the same
place. Their uses of hidden and non-hidden files are also compatible.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales