A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More

Alexander Haneng
Jul 19, 2012
  12557
(5 votes)

EPiServer 7: There is already an open DataReader associated with this Command which must be closed first.

I ran into the following error on an EPiServer 7 Preview site today:

There is already an open DataReader associated with this Command which must be closed first.”

The problem is that EPiServer 7 requires that the MultipleActiveResultSets is set to true in the connection string.

 

ConnectionStrings.config:

<connectionStrings>
  <clear />
  <add name="EPiServerDB" 
       connectionString="Data Source=(local)\SQLEXPRESS;
         Initial Catalog=epi;
         Integrated Security=False;
         User ID=user;
         Password=pwd;
         MultipleActiveResultSets=True" 
       providerName="System.Data.SqlClient" />
</connectionStrings>

 

 

image

Jul 19, 2012

Comments

Eric
Eric Jun 5, 2013 04:17 PM

Awsome. Strange but this did not occur when I had the db localy on my machine but on a shared server. Still same problem with episerver cms 7 the released version.

Eric
Eric Jun 5, 2013 04:17 PM

deleted post

Ted Callander
Ted Callander Jun 9, 2014 11:17 PM

Thanks, solved my problem :)

Please login to comment.
Latest blogs
CMS Audiences - check all usage

Sometimes you want to check if an Audience from your CMS (former Visitor Group) has been used by which page(and which version of that page) Then yo...

Tuan Anh Hoang | Dec 12, 2025

Data Imports in Optimizely: Part 2 - Query data efficiently

One of the more time consuming parts of an import is looking up data to update. Naively, it is possible to use the PageCriteriaQueryService to quer...

Matt FitzGerald-Chamberlain | Dec 11, 2025 |

Beginner's Guide for Optimizely Backend Developers

Developing with Optimizely (formerly Episerver) requires more than just technical know‑how. It’s about respecting the editor’s perspective, ensurin...

MilosR | Dec 10, 2025

Optimizely PaaS Administrator Certification : Free for Everyone

Optimizely has recently launched a free PaaS Administrator Certification. https://academy.optimizely.com/student/activity/2958208-paas-cms-administ...

Madhu | Dec 9, 2025 |