python 3.8
pymssql 2.2.8
python连接MSSQL报错20002:
pymssql._mssql.MSSQLDatabaseException: (20002, b'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (...)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (...)\n')
按照网上查询的增加charset='cp936'也没有用,但用SSMS连接没问题
conn = pymssql.connect(host='*.*.*.*', port = '1433', user='*', password='*', database='*', charset = 'cp936')