Linux下安裝pymssql及簡單嘗試

標籤：server   database   password   python   xxxxxx   

安裝pymssql模組：

centos :

　　　　yum install python-devel python-setuptools

去https://pypi.python.org/pypi/pymssql/2.1.0  下載源碼包  wget https://pypi.python.org/packages/source/p/pymssql/pymssql-2.1.0.tar.gz#md5=e955442a8cd43456cdf5c28b75147afb

yum install freetds-devel

python setup.py build

python setup.py install

一定要裝freetds-devel ，不然編譯會報gcc的錯。

正確編譯以後應該可以在python 中import pymssql。

window版：

https://pypi.python.org/pypi/pymssql/2.1.1#downloads

#!/usr/bin/python

import pymssql,sys

conn = pymssql.connect(server=‘192.168.1.252‘,port=‘1433‘,user=‘sa‘,password=‘xxxxxx‘,database=‘xxxx‘, charset=‘UTF-8‘)

print ‘connect ok....‘

cursor = conn.cursor()

sql = ‘select count(*) from sys.dm_exec_connections‘

cursor.execute(sql)

row = cursor.fetchone()

print (row[0])

conn.close()

Linux下安裝pymssql及簡單嘗試