1、pymssql安装(Linux)
下载pymsql:https://pypi.python.org/pypi/pymssql
注意:先切换root权限:
sudo su -
sudo apt-get install freetds-dev
cd /home/pi/pymssql
tar zxvf pymssql-2.1.3.tar.gz
cd /home/pi/pymssql/pymssql-2.1.3
python3 setup.py install
注意: 如果安装Python2.x环境下的pymssql 需要再前置安装
sudo apt-get install python-dev
然后运行 python setup.py install
2、pymssql安装(windows)
先下载pymssql模块:http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql%20
打开cmd命令行运行
pip install C:\pymssql-2.1.3-cp35-cp35m-win_amd64.whl
3、pymssql调用方法类
1 #coding=utf-8 #!/usr/bin/env python 2 3 import pymssql 4 5 class MSSQL: 6 def __init__(self): 7 self.host = '' 8 self.user = '' 9 self.pwd = '' 10 self.db = '' 11 12 def __GetConnect(self): 13 """ 14 得到连接信息 15 返回: conn.cursor()