pip install pyodbc
In file included from .../build/pyodbc/src/buffer.cpp:12:
.../build/pyodbc/src/pyodbc.h:52:10: fatal error: 'sql.h' file not found
1 error generated.
error: command 'cc' failed with exit status 1
As you noticed OSX Mavericks dropped sql headers that are required for PyODBC compilation. Following these steps allowed me to install PyODBC:
pip install --no-install pyodbc
python setup.py build_ext --include-dirs=[LIBIODBC_SOURCES]/include/
pip install --no-download pyodbc:
Installing collected packages: pyodbc Running setup.py install for pyodbc warning: no files found matching 'tests/*' Successfully installed pyodbc Cleaning up...
I could as well copy the files under
[libiodbc_sources]/include/ to my
/usr/include and just run
pip install pyodbc, but I didn't want to add files manually to system folders.