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