VS2019 Python连接Sql server2008（20002错误）

安好后： 

 

测试代码：

import pymssql

try:

    conn = pymssql.connect(host='127.0.0.1',

    user='sa',

    password='123456',

    database='hotel',

    charset='utf8')

# 连接并执行Sql语句

    cursor = conn.cursor()
    
    sql = 'select * from oder'

    cursor.execute(sql)

    # 获取数据集

    rs = cursor.fetchall()

    print(rs)

except Exception as ex:

    print(ex)

finally:

    conn.close()

乱码

 解决：

用Python的Pyms