isql works, not python: NoSQLGetPrivateProfileString error

[yang]

Anyone know why this might be happening?

Code: Select all

$ cat ~/.odbc.ini
[ODBC Data Sources]
VerticaDSN = "bigbang"

[bigbang]
Driver = /opt/vertica/lib64/libverticaodbc.so
Database = bigbang
Servername = localhost
UID = dbadmin
PWD = ...
Port = 5433

$ LD_LIBRARY_PATH=/opt/vertica/lib64:/opt/vertica/lib64/libverticaodbc.so:$LD_LIBRARY_PATH python -c "import pyodbc; pyodbc.connect('DSN=bigbang')"
Traceback (most recent call last):
  File "<string>", line 1, in <module>
pyodbc.Error: ('HY000', '[HY000] [unixODBC][DSI] The error message NoSQLGetPrivateProfileString could not be found in the en-US locale. Check that /en-US/ODBCMessages.xml exists. (-1) (SQLDriverConnect)')

$ isql -v bigbang
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

[id10t]

Hi yang!

viewtopic.php?f=21&t=209&p=512

PS use search, read docs

[yang]

I did actually already see that but configuring vertica.ini/VERTICAINI doesn't appear to be doing anything for me.

Edit: Actually it does work. I wasn't exporting my environment variable correctly.

[JimKnicely]

Cool! So you got it working, yang?

[yang]

Yes, thank you