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
****