代码设置:
conn = pymssql.connect(host="test..com:1456", user="", password="", database="Test_System", charset='utf8')
部分人可以执行,但也存在部分人执行程序会提示出现以下错误:
Traceback (most recent call last):
File "src\pymssql.pyx", line 636, in pymssql.connect
File "src_mssql.pyx", line 1964, in _mssql.connect
File "src_mssql.pyx", line 682, in _mssql.MSSQLConnection.init
File "src_mssql.pyx", line 1690, in _mssql.maybe_raise_MSSQLDatabaseException
_mssql.MSSQLDatabaseException: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (test..com)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (test.**.com)\n')
后面修改成
conn = pymssql.connect(host="test..com:1456", user="", password="****", database="Test_System", charset='CP936')
就可以执行,但对于后面代码操作数据库不好操作,update插入到数据库显示中文内容出现乱码;
但设置回charset='utf8'更新到数据库显示中文内容是正常的
求解救