Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

使用SqlServer连接,多客户端访问报错(not support MultipleActiveResultSets) #182

Closed
anjoy8 opened this issue May 7, 2021 · 3 comments

Comments

@anjoy8
Copy link
Owner

anjoy8 commented May 7, 2021

🌳 报错信息 - There is already an open DataReader associated with this Command which must be closed first.

排查问题:
1、异步代码里,是否写了同步的方法或代码
2、SqlServer版本要2012及以上,其他数据库请参考:#148
3、尽量使用最近3个月内的代码

@anjoy8 anjoy8 changed the title 使用SqlServer连接,多客户端报错(not support MultipleActiveResultSets) 使用SqlServer连接,多客户端访问报错(not support MultipleActiveResultSets) May 7, 2021
@anjoy8 anjoy8 closed this as completed May 7, 2021
@anjoy8 anjoy8 pinned this issue May 7, 2021
@anjoy8
Copy link
Owner Author

anjoy8 commented May 7, 2021

4、可以尝试在连接字符串中,加上
MultipleActiveResultSets=true

@yuzhupeng
Copy link

yuzhupeng commented Mar 2, 2022

使用 sqlserver 数据库 初始化 TopicDetail表的数据,有问题,重新编辑数据后就正常了
[
{
"TopicId": 1,
"tdLogo": "",
"tdName": "第一章 罗马的诞生 第一节 传说的年代",
"tdContent": "

第一节 希腊士兵屠杀 。",
"tdSectendDetail": "",
"tdIsDelete": 0,
"tdRead": 8,
"tdCommend": 0,
"tdGood": 0,
"tdCreatetime": "/Date(1546272000000+0800)/",
"tdUpdatetime": "/Date(1546272000000+0800)/",
"tdTop": 0,
"tdAuthor": "",
"Id": 1
}
]

@anjoy8
Copy link
Owner Author

anjoy8 commented May 9, 2023

初始化的时候,如何有中文问号,可以配置属性
#344

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants