如何在 MacOS Sierra 上安装 pymssql

Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/tmp/pip-build-J1I0ox/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-qmtdBW-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/tmp/pip-build-J1I0ox/pymssql/

我遇到了与显示相同的错误here https://stackoverflow.com/questions/30646171/error-installing-pymssql-on-mac-os-x-yosemite。我按照该页面上的说明尝试brew install freetds其次是sudo -H pip install pymssql.

这会生成以下错误代码：

    _mssql.c:18814:15: error: use of undeclared identifier 'DBVERSION_80'
    __pyx_r = DBVERSION_80;
              ^
4 warnings and 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-J1I0ox/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-qmtdBW-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/tmp/pip-build-J1I0ox/pymssql/

搜索这个错误让我发现这一页 https://stackoverflow.com/questions/37771434/mac-pip-install-pymssql-error。我按照那里发布的解决方案尝试了这两种方法 brew unlink freetds; brew install homebrew/versions/freetds091 and brew uninstall freetds; brew install homebrew/versions/freetds091尝试时会产生不同的错误 sudo -H pip install pymssql:

_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/var/folders/_s/27xppw4j3yl78c9l4v1w3n9m0000gn/T/pip-build-97A9sQ/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 /var/folders/_s/27xppw4j3yl78c9l4v1w3n9m0000gn/T/pip-0nUZo4-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/var/folders/_s/27xppw4j3yl78c9l4v1w3n9m0000gn/T/pip-build-97A9sQ/pymssql/

所以后来我放弃并尝试安装 pyodbc，但我仍然遇到类似的错误： src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include sql.h

对此的任何帮助都会很棒。

这个链接 https://github.com/pymssql/pymssql/issues/129最终解决了我的问题。对于遇到这些问题的其他人来说，这一系列命令对我有用。

brew uninstall --force freetds
brew install [email protected] /cdn-cgi/l/email-protection
brew link --force [email protected] /cdn-cgi/l/email-protection
pip install pymssql