export PATH=$PATH:/usr/local/nz/bin64
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/nz/lib:/usr/local/nz/lib64
export ODBCINI=/etc/odbc.ini
export NZ_ODBC_INI_PATH=/etc

[ODBC Drivers]
NetezzaSQL = Installed

[NetezzaSQL]
#Driver           = /usr/local/nz/lib/libnzodbc.so
Driver           = /usr/local/nz/lib64/libnzodbc.so
#Setup            = /usr/local/nz/lib/libnzodbc.so
Setup            = /usr/local/nz/lib64/libnzodbc.so
APILevel         = 1
ConnectFunctions = YYN
Description      = Netezza ODBC driver
DriverODBCVer    = 03.51
DebugLogging     = false
LogPath          = /tmp
UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch         = 256
Socket           = 16384

[NZSQL]
;Path of a driver used for database connection
#Driver                = /usr/local/nz/lib/libnzodbc.so
Driver                = /usr/local/nz/lib64/libnzodbc.so

;A decription used to identify the database connection properties.
#Description           = NetezzaSQL ODBC
Description           = NetezzaSQL

;The name of a machine or IP address where the database is located.
#Servername            = 127.0.0.1
Servername            = 172.15.123.135

;The port number to connect.
Port                  = 5480

;The name of a database.
#Database              = dev
Database              = some_db

;The name of a valid user.
#Username              = guest
Username              = some_user

;The password for  the user.
#Password              = password
Password              = some_password

;Only Select SQL statements will be allowed if this field is checked.
ReadOnly              = false

;When set to true, system tables will be included in the available table list.
ShowSystemTables      = false

;When set to true, use old (2.5) functionality for returning schemas in SQLTables.
LegacySQLTables       = false

;Specifies login timeout in seconds.
LoginTimeout          = 0

;Specifies query timeout in seconds.
QueryTimeout          = 0

;Specifies date format as follows -
; 1: YMD
; 2: MDY
; 3: DMY
DateFormat            = 1

;When selected, driver treats SQL_C_NUMERIC buffers as SQL_C_CHAR buffers.
NumericAsChar         = false

;Return SQL_BIT as "1"/"0" when char.
SQLBitOneZero         = false

;When enabled, replaces all occurences of CRLF, CR and LF with a single space.
StripCRLF             = false

;Specifies level of security on the system
securityLevel         = preferredUnSecured

;Name of the Root CA certificate.
caCertFile            =

;Specifies maximum errors allowed. 0 value means no limit on loadMaxErrors value.
;loadMaxErrors         = 1

;If value is true, it rounds the data of numeric columns whose precision exceeds the precision defined.
;loadRoundFraction     = 0


[ODBC]
IANAAppCodePage=4
InstallDir=/opt/odbc32v51
Trace=0
TraceDll=/opt/odbc32v51/lib/odbctrac.so
TraceFile=odbctrace.out
UseCursorLib=0

[root@kc1060 mysql]# isql NZSQL
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

[root@sms003 ~]# mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 106
Server version: 10.0.16-MariaDB-log MariaDB Server

Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use test;
Database changed
MariaDB [test]> create table odbc_test engine=connect table_type=ODBC tabname='some_table' connection='DSN=NZSQL';
ERROR 1105 (HY000): [unixODBC]Server and/or port attributes are empty