在使用sqlalchemy和pyodbc连接sqlserver时出现了一个神奇的报错
sqlalchemy.exc.DBAPIError: (pyodbc.Error) ('HY010', '[HY010] [Microsoft][SQL Server Native Client 10.0]函数序列错误 (0) (SQLFetch)')
报错在数据库工具的session执行完sql语句、保留sqlalchemy.engine.result.ResultProxy变量、session进行commit操作后返回sqlalchemy.engine.result.ResultProxy变量后,由数据库工具的调用方使用sqlalchemy.engine.result.ResultProxy对象进行fetchall操作时报错。
# 数据库连接代码
DB_information = {
"library": {
"host":"127.0.0.1", "db":"mysql","user":"root", "password":"123456", "database":"library", "charset":"utf8", "API":"mysqldb","port":"3306"},
"SS_work": {
"host":"127.0.0.1", "db":"mssql","user":"boss", "password":"123456", "database":"db_Workplace", "charset":"utf8", "API":"pyodbc","port":"1433","driver":"SQL Server Native Client 10.0"}
}
session_dict = {