Question

python用pymssql连接数据库时出现未知错误的问题

import pymssql
conn = pymssql.connect(host="localhost",user="sa",password="pwd",database="production")

运行后，错误代码如下

Traceback (most recent call last):
File "I:/py/m.py", line 2, in <module>
conn = pymssql.connect(host="localhost",user="sa",password="pwd",database="production")
File "pymssql.pyx", line 577, in pymssql.connect (pymssql.c:9000)
OperationalError: (20009, 'Net-Lib error during Unknown error')

求大神解答，小弟初学，赶紧不尽！

Answer 1

import pymssql

conn=pymssql.connect(host="localhost",user="sa",password="pwd",database="production",charset='utf8')

缺少后边的charset是很容易报错的

Answer 2

conn = pymssql.connect(host=r"localhost",user=r"sa",password=r"pwd",database=r"production")

stack overflow 上有个类似的问题 有个答案是这样的 你试试 没用过mssql

追问

求链接。。

追答

没解决？

http://stackoverflow.com/questions/15706078/pymssql-python-connection-string

也不知道百度让不让发链接…另外这个好像被墙了 你试试吧