Loading... <p><span>依赖安装:</span></p> <p>freetds、python-devel、cython、Python3.x</p> <p></p> <p><span>1、安装freetds</span></p> <pre class="brush:bash;toolbar:false">tar -jxvf freetds-dev.0.99.134.tar.bz cd freetds-dev.0.99.134 ./configure --prefix=/usr/local/freetds --with-tdsver=7.0 --enable-msdblib --with-gnu-ld --enable-shared --enable-static echo "/usr/local/freetds/lib" >> /etc/ld.so.conf.d/freetds.conf ldconfig -v</pre> <p></p> <p><span>2、安装Python3.x</span></p> <pre class="brush:bash;toolbar:false">tar -zxvf Python-3.5.1.tgz cd Python-3.5.1 ./configure make && make install</pre> <p></p> <h3><span>3、安装cython</span></h3> <pre class="brush:bash;toolbar:false">pip3 install cython</pre> <p></p> <h3><span>4、安装pymssql</span></h3> <pre class="brush:bash;toolbar:false">export PYMSSQL_BUILD_WITH_BUNDLED_FREETDS=1 pip3 install pymssql</pre> <p></p> <p><span>测试连接</span></p> <pre class="brush:bash;toolbar:false">#!/usr/local/bin/python3.5 import pymssql conn = pymssql.connect(host="x.x.x.x", user="sa", password="password",database="sys", charset='utf8', port='1433', as_dict=False) print ('connect ok....') cursor = conn.cursor() sql = 'SELECT column FROM table WHERE key=key_id;' cursor.execute(sql) row = cursor.fetchone() print (row[0]) conn.close()</pre> <p></p> <p><span>参考博客</span>:<span>http://leovlys.iteye.com/blog/2283832</span></p> 最后修改:2021 年 12 月 10 日 10 : 53 AM © 允许规范转载 赞赏 如果觉得我的文章对你有用,请随意赞赏 赞赏作者 支付宝微信