ODBC to Netezza Database Connection issue


I am getting a funny error for Pyodbc  I used the code below and the Error I
received running the code is below. I have also attached the configuration 
files.

This is the code that I have entered using python 2.6 in linux Red Hat 64bit

import pyodbc

print pyodbc.dataSources()

print "Connecting via ODBC"

conn = 
pyodbc.connect("DRIVER={NetezzaSQL};SERVER=localhost;PORT=5668;DATABASE=Database
;UID=santiago;PWD=ha123;")
Error

This is the true error I received when running pyodbc. I don't know what this 
language is or what it means?

{'ODBC': '', 'NetezzaSQL': '/usr/local/nz_7.2.0.3/lib64/libnzodbc.so'}
Connecting via ODBC
Traceback (most recent call last):
  File "connect.py", line 41, in <module>
conn = 
pyodbc.connect("DRIVER{NetezzaSQL};SERVER=localhost;PORT=5668;DATABASE=Database;
UID=santiago;PWD=ha123;")
pyodbc.Error: ('H00', '[H00] [unixODBC]Sre n/rpr trbtsaeepy\xc8 (33) 
(SQLDriverConnectW)')
obdcinst.ini

Original issue reported on code.google.com by fandango...@gmail.com on 1 Apr 2015 at 3:14

Attachments:

moreandres / pyodbc

ODBC to Netezza Database Connection issue #395