Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

Alexander Haneng
Jul 19, 2012
  11728
(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

Jun 9, 2014 11:17 PM

Thanks, solved my problem :)

Please login to comment.
Latest blogs
Solving the mystery of high memory usage

Sometimes, my work is easy, the problem could be resolved with one look (when I’m lucky enough to look at where it needs to be looked, just like th...

Quan Mai | Apr 22, 2024 | Syndicated blog

Search & Navigation reporting improvements

From version 16.1.0 there are some updates on the statistics pages: Add pagination to search phrase list Allows choosing a custom date range to get...

Phong | Apr 22, 2024

Optimizely and the never-ending story of the missing globe!

I've worked with Optimizely CMS for 14 years, and there are two things I'm obsessed with: Link validation and the globe that keeps disappearing on...

Tomas Hensrud Gulla | Apr 18, 2024 | Syndicated blog

Visitor Groups Usage Report For Optimizely CMS 12

This add-on offers detailed information on how visitor groups are used and how effective they are within Optimizely CMS. Editors can monitor and...

Adnan Zameer | Apr 18, 2024 | Syndicated blog