The following example illustrates how you might edit odbc.ini to connect to a data source database, such as “NZSQL”, using a vendor-supplied ODBC driver.
[ODBC Data Sources] NZSQL = NetezzaSQL ... [NZSQL] Driver = /usr/local/nz/lib/libnzodbc.so Description = NetezzaSQL ODBC Servername = <123.4.5.6> Port = 5480 Database = system Username = admin Password = password ReadOnly = false ShowSystemTables = false LegacySQLTables = false LoginTimeout = 0 QueryTimeout = 0 DateFormat = 1 NumericAsChar = false SQLBitOneZero = false StripCRLF = false