mac python2.7安装pymssql

转载自：https://blog.csdn.net/fengyang_123456/article/details/72865599

 

Mac环境：10.12.3（15G31）

python:2.7.10

sudo pip install pymssql 后出现下面问题：

setup.py: Not using bundled FreeTDS 
setup.py: include_dirs = [‘/usr/local/include’] 
setup.py: library_dirs = [‘/usr/local/lib’] 
running install 
running build 
running build_ext 
building ‘_mssql’ extension 
creating build 
creating build/temp.macosx-10.11-intel-2.7 
cc -fno-strict-aliasing -fno-common -dynamic -arch i386 -arch x86_64 -g -Os -pipe -fno-common -fno-strict-aliasing -fwrapv -DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes -Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes -DENABLE_DTRACE -arch i386 -arch x86_64 -pipe -I/usr/local/include -I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7 -c _mssql.c -o build/temp.macosx-10.11-intel-2.7/_mssql.o -DMSDBLIB 
_mssql.c:266:10: fatal error: ‘sqlfront.h’ file not found

include “sqlfront.h”
^ 
1 error generated. 
error: command ‘cc’ failed with exit status 1

Command “/usr/bin/python -u -c “import setuptools, tokenize;file=’/private/tmp/pip-build-6afCqj/pymssql/setup.py’;f=getattr(tokenize, ‘open’, open)(file);code=f.read().replace(‘\r\n’, ‘\n’);f.close();exec(compile(code, file, ‘exec’))” install –record /tmp/pip-Q1Ludg-record/install-record.txt –single-version-externally-managed –compile” failed with error code 1 in /private/tmp/pip-build-6afCqj/pymssql/ 
解决方案： 
1. brew unlink freetds 
2. brew install freetds@0.91 
3. brew link –force freetds@0.91 
4. sudo pip2.7 install pymssql