I usually access an ODBC connection through a CentOS server, and I'm trying to make the same connection locally on my Ubuntu Trusty laptop. So far as I can tell I've duplicated everything properly across the two machines, but I just can't get it to work. I had it working on an old laptop on the same network, so I think I can rule out firewalls/routing/etc.
When I try to test the connection I get:
me@T420:~/tmp$ iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0709.0909
Enter ODBC connect string (? shows list): ?
DSN | Driver
------------------------------------------------------------------------------
NZSQL_SERVER | NetezzaSQL
Enter ODBC connect string (? shows list): NZSQL_SERVER
1: SQLDriverConnect = ������ (33) SQLSTATE=
1: ODBC_Connect = ������ (33) SQLSTATE=
my /etc/odbcinst.ini:
Have a nice day.patrickmc@patrickmc-ThinkPad-T420:~/tmp$ cat /etc/odbcinst.ini
[ODBC Drivers]
NetezzaSQL = Installed
[NetezzaSQL]
Description = Netezza ODBC Driver
Driver = /usr/local/nz/lib64/libnzodbc.so
Setup = /usr/local/nz/lib64/libnzodbc.so
FileUsage = 1
APILevel = 1
ConnectFunctions = YYN
DriverODBCVer = 03.50
UnicodeTranslationOption = utf8
CharacterTranslationOption = all
PreFetch = 256
Socket = 8192
LogPath = /tmp
DebugLogging = false
[ODBC]
Trace = No
and my /etc/odbc.ini:
;
; odbc.ini
;
[ODBC Data Sources]
NZSQL_SERVER = NetezzaSQL
[NZSQL_SERVER]
Driver = /usr/local/nz/lib64/libnzodbc.so
Description = NetezzaSQL ODBC
Servername = db.mynetwork.net
Port = 5480
Database = db_1
Username = db_user
Password = db_pass
ReadOnly = false
ShowSystemTables = true
LegacySQLTables = false
LoginTimeout = 0
QueryTimeout = 0
DateFormat = 1
NumericAsChar = false
SQLBitOneZero = false
StripCRLF = false
securityLevel = preferredUnSecured
caCertFile =