【初学者】python pymssql模块连接sql server服务器不成功有关问题

【菜鸟求助】python pymssql模块连接sql server服务器不成功问题
python2.7 for windows ,pymssql_win32 for py2.7已经安装。win7 32位系统，sqlserver2005绝对可以正常连接。

从网上学习了一段连接sql server的代码，可是在自己的机器上调试，总是报错。

代码如下：

Python code

import pymssqlcon=pymssql.connect(host='10.116.5.176',user='sa',password='123456',database='MASTER_CNBJ')cur=con.cursor()cur.execute("select * from Price_CNBJ")print cur.fetchall()cur.close()con.close()

以上为网上千篇一律的入门代码，可惜运行时报如下错误。

Python code

Traceback (most recent call last):  File "C:/Users/smc8236/Desktop/connSqlserver1", line 2, in <module>    con=pymssql.connect(host='10.116.5.176',user='sa',password='123456',database='MASTER_CNBJ')  File "pymssql.pyx", line 549, in pymssql.connect (pymssql.c:7112)OperationalError: (20017, '\xc4DB-Lib error message 20017, severity 9:\nUnexpected EOF from the server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed\n')

查阅一些资料也没有解决，特此求大师指点迷津。


[解决办法]
看下这个：
http://pyyou.wordpress.com/2009/02/01/install-pymssql-and-how-to-deal-with-db-lib-error-message-20009-severity-9/

引用网页内容:

...
So I use an another environnement variable to fix that :

export TDSVER=7.0

And miracle , everything work with tsql. So I force version of tds in my ~/.freetds.conf in global section as this

[global]
tds version = 7.0
...

查看更多 下一篇