brainstormflash
7/4/2017 - 8:41 AM

PYODBC problems

PYODBC problems

cat /Library/Vertica/ODBC/lib/vertica.ini
****
[ODBC Drivers]
MySQL ODBC 5.3 Unicode Driver = Installed
MySQL ODBC 5.3 ANSI Driver    = Installed
Vertica                       = Installed

[ODBC Connection Pooling]
PerfMon    = 0
Retry Wait =

[MySQL ODBC 5.3 Unicode Driver]
Driver = /usr/local/lib/libmyodbc5w.so

[MySQL ODBC 5.3 ANSI Driver]
Driver = /usr/local/lib/libmyodbc5a.so

[Vertica]
Driver = /Library/Vertica/ODBC/lib/libverticaodbc.dylib

****
make sure env variables:
EXPORT ODBCINI=$HOME/.odbc.ini
export VERTICAINI=/usr/local/etc/vertica.ini
****
make sure pyodbc version in requirements file is pyodbc==3.0.7
****