1、安装freetds
2、安装pymssql
3、vim ~/.bash_profile export TDSVER=7.0
4、source ~/.bash_profile
有时候会出现
>>> import pymssql
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "pymssql.py", line 30, in <module>
import _mssql, types, string, time, datetime, warnings
ImportError: libsybdb.so.5: cannot open shared object file: No such file or directory
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "pymssql.py", line 30, in <module>
import _mssql, types, string, time, datetime, warnings
ImportError: libsybdb.so.5: cannot open shared object file: No such file or directory
是找不到libsybdb.so.5这个动态链接库文件
那么find这个文件,并将这个文件放到ld_config的目录中去或则将文件所在目录添加到/etc/ld.so.conf中
执行ldconfig命令加载
然后就ok了