Collecting pymssql
Downloading http://mirrors.aliyun.com/pypi/packages/4c/c8/5ad36d8d3c304ab4f310c89d0593ab7b6229568dd8e9cde927311b2f0c00/pymssql-2.1.3.tar.gz (897kB)
100% |████████████████████████████████| 901kB 331kB/s
Installing collected packages: pymssql
Running setup.py install for pymssql ... error
Complete output from command /usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/var/folders/rs/dc06sf0j27n3xjzsr0m5r2h40000gn/T/pip-build-A6n9LJ/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/rs/dc06sf0j27n3xjzsr0m5r2h40000gn/T/pip-5DYkVx-record/install-record.txt --single-version-externally-managed --compile:
setup.py: platform.system() => 'Darwin'
setup.py: platform.architecture() => ('64bit', '')
setup.py: platform.libc_ver() => ('', '')
setup.py: Detected Darwin/Mac OS X.
You can install FreeTDS with Homebrew or MacPorts, or by downloading
and compiling it yourself.
Homebrew (http://brew.sh/)
--------------------------
brew install freetds
MacPorts (http://www.macports.org/)
-----------------------------------
sudo port install freetds
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:18814:15: error: use of undeclared identifier 'DBVERSION_80'
__pyx_r = DBVERSION_80;
^
1 error generated.
error: command 'cc' failed with exit status 1
----------------------------------------
Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/private/var/folders/rs/dc06sf0j27n3xjzsr0m5r2h40000gn/T/pip-build-A6n9LJ/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/rs/dc06sf0j27n3xjzsr0m5r2h40000gn/T/pip-5DYkVx-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /private/var/folders/rs/dc06sf0j27n3xjzsr0m5r2h40000gn/T/pip-build-A6n9LJ/pymssql/````
mac上安裝pymssql會提示這樣的錯誤.
```__pyx_r = DBVERSION_80;```
這是因為freetds版本比較高的問題.
只需要先解除安裝freetds,然後在安裝低版本
```brew unlink freetds
brew install homebrew/versions/freetds091```
然後重新安裝pymssql就好
感謝stackoverflow
`http://stackoverflow.com/questions/37771434/mac-pip-install-pymssql-error`
複製程式碼