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