Installing pymssql in Centos 6.6 64-bit

Question

I'm trying to pip install pymssql in my Centos 6.6, but kept on experiencing this error:

_mssql.c:314:22: error: sqlfront.h: No such file or directory cpp_helpers.h:34:19: error: sybdb.h: No such file or directory

I already installed freetds, freetds-devel, and cython. Any ideas? Thanks in advance!

Answer 1

Looking at the full traceback we see that include_dirs includes /usr/local/include but the header files are in /usr/include which I imagine has to do with the fact python 2.7 is not the system python.

You can change the setup.py script to include /usr/include or copy the files into /usr/local/include