Skip to content

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

Closed

Description

@anjoy8

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

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

Activity

  1. changed the title [-]使用SqlServer连接,多客户端报错(not support MultipleActiveResultSets)[/-] [+]使用SqlServer连接,多客户端访问报错(not support MultipleActiveResultSets)[/+] on May 7, 2021
  2. pinned this issue on May 7, 2021
  3. anjoy8 commented on May 7, 2021

    @anjoy8
    OwnerAuthor

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

  4. yuzhupeng commented on Mar 2, 2022

    @yuzhupeng

    使用 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
    }
    ]

  5. anjoy8 commented on May 9, 2023

    @anjoy8
    OwnerAuthor

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions