A-4 20751-12 Rev.5
Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide
2. Shared Configuration Files. Use this method if you would like all users of the Linux/
UNIX client system to use the same set of ODBC configuration files. Configure the
NZ_ODBC_INI_PATH environment variable so it specifies the /etc directory, and
place the two non-hidden configuration files odbcinst.ini and odbc.ini in the
/etc directory. The DataDirect driver manager and the Netezza ODBC driver then both
find the configuration files in the /etc directory.
3. Two environment variables. Use this method if you would like both the Netezza ODBC
driver and DataDirect driver manager to find the configuration files no matter where
they are on the filesystem. Use both NZ_ODBC_INI_PATH and ODBCINI together to
point to the odbc.ini and odbcinst.ini files anywhere on the filesystem.
Investigating Client System Configuration
Sometimes, you may need to change the configuration of a UNIX/Linux client system to
access new Netezza appliance data sources after the system has previously been config-
ured to access other types of ODBC data sources. Such a system might already have a
driver manager installed and ODBC configuration files located in some directory in the file
system. In such a situation, you will find it helpful to discover as much about the present
configuration as you can before deciding how to configure the Netezza ODBC drivers and
Netezza appliance data sources.
One technique is to use the env and grep commands to determine if there already exist
one or more environment variables that point to ODBC configuration directories. You may
find the following command useful:
env | grep -i ODBC
The information displayed by the above command tells you if there are any entries in the
environment that contain the characters ODBC. You might see a result like the following:
ODBC_HOME=/opt/odbc
or
ODBCINI=/opt/odbc/odbc.ini
Results such as the above give you clues as to how the client system is presently config-
ured. You can than look in the referenced directories for ODBC configuration files, and then
configure the Netezza ODBC driver to look in those same directories for the ODBC configu-
ration files.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce