Installing pyodbc fails on OSX 10.9 (Mavericks)

Question

When running pip install pyodbc, I get

In file included from .../build/pyodbc/src/buffer.cpp:12:     .../build/pyodbc/src/pyodbc.h:52:10: fatal error: 'sql.h' file not found     #include <sql.h>              ^     1 error generated.     error: command 'cc' failed with exit status 1 

It seems that Mavericks has no sql.h under /usr/include

Did anyone manage to install pyodbc? Is there a known workaround?

Answer 1

You can use Homebrew to install unixodbc, then pyodbc via pip in the usual fashion.

brew install unixodbc && pip install pyodbc 

This works for me on Mavericks.

Answer 2

As you noticed OSX Mavericks dropped sql headers that are required for PyODBC compilation. Following these steps allowed me to install PyODBC:

1. Make sure you have iODBC library installed (http://www.iodbc.org/)
2. Download and extract iODBC sources
3. Run pip install --no-install pyodbc
4. cd [VIRTUAL_ENV]/build/pyodbc
5. Run python setup.py build_ext --include-dirs=[LIBIODBC_SOURCES]/include/

6. Run 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.