如何在MacOS上安装pymssql Sierra
问题描述:
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显示的错误相同。我按照brew install freetds
后跟sudo -H pip install pymssql
的指示在该页面上进行了操作。如何在MacOS上安装pymssql Sierra
生成此错误代码:
_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/
搜索这个错误把我带到 this page。
_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
sudo -H pip install pymssql
我接着尝试都
brew unlink freetds; brew install homebrew/versions/freetds091
和
brew uninstall freetds; brew install homebrew/versions/freetds091
产生不同的错误张贴在那里的解决方案
任何帮助,这将是伟大的。
答
This link最终解决了我的问题。对于有这些问题的任何人,这个命令序列对我来说很合适。
brew uninstall --force freetds
brew install [email protected]
brew link --force [email protected]
pip install pymssql
您是否试图通过brew安装'unixodbc'('brew install unixodbc')?它包含你缺少的'sql.h'。 – Zaphod