PyODBC and iODBC on Linux

[eduard93]

We need to build PyODBC with iODBC support on Linux if we want to support ODBC.

mkleehammer/pyodbc#444

https://stackoverflow.com/questions/2960339/unable-to-install-pyodbc-on-linux

import pyodbc
cnxn=pyodbc.connect(('Driver=/usr/irissys/bin/libirisodbciw35.so;Server=localhost;Port=51773;Namespace=USER;UID=_SYSTEM;PWD=SYS;Authentication Method=0'),autocommit=True)
Data=pd.read_sql('SELECT * FROM isc_py_test.CannibalizationData',cnxn)
cnxn.close()

[eduard93]

apt-get update && apt-get install -y g++ unixodbc-dev

[eduard93]

This works:
cnxn=pyodbc.connect(('Driver=/usr/irissys/bin/libirisodbcu35.so;Server=localhost;Port=51773;database=USER;UID=_SYSTEM;PWD=SYS;Authentication Method=0'),autocommit=True)