Compatibility of ODBC driver and unixODBC driver manager with respect to configuration files

The methods that the ODBC driver and the unixODBC driver manager use to locate the two ODBC configuration files are compatible. It is relatively easy to ensure that the Netezza Performance Server ODBC driver and the unixODBC driver manager find the configuration files in the same place. Their uses of hidden and non-hidden files are also compatible.

If each user must access different Netezza Performance Serversystem data sources, place hidden configuration files in the home directory of each user. If all users access the same Netezza Performance Server system data sources, place non-hidden configuration files in the /usr/local/etc directory.

With the unixODBC driver manager, you do not need to use the NZ_ODBC_INI_PATH environment variable.