mac安装pymssql时报错

pip install pymssql

出现的报错信息：

_mssql.c:266:10: fatal error: 'sqlfront.h' file not found

    #include "sqlfront.h"

             ^

    1 error generated.

    error: command 'gcc' failed with exit status 1

 

解决方案：

（1）brew install freetds@0.91

（2）brew link --force freetds@0.91

如果之前的配置连接已存在

Linking /usr/local/Cellar/freetds@0.91/0.91.112...

Error: Could not symlink etc/locales.conf

Target /usr/local/etc/locales.conf

already exists. You may want to remove it:

  rm '/usr/local/etc/locales.conf'

 

To force the link and overwrite all conflicting files:

  brew link --overwrite freetds@0.91

 

To list all files that would be deleted:

  brew link --overwrite --dry-run freetds@0.91

➜  ~ rm '/usr/local/etc/locales.conf'

➜  ~ brew link --force freetds@0.91

Linking /usr/local/Cellar/freetds@0.91/0.91.112...

Error: Could not symlink etc/pool.conf

Target /usr/local/etc/pool.conf

already exists. You may want to remove it:

  rm '/usr/local/etc/pool.conf'

 

To force the link and overwrite all conflicting files:

  brew link --overwrite freetds@0.91

 

To list all files that would be deleted:

  brew link --overwrite --dry-run freetds@0.91

➜  ~ rm '/usr/local/etc/pool.conf'

➜  ~ brew link --force freetds@0.91

（3）sudo pip install pymssql

成功安装完成以后可以得到以下信息

Installing collected packages: pymssql

  Running setup.py install for pymssql ... done

Successfully installed pymssql-2.1.3