Alexander Haneng
Jul 19, 2012
  11992
(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
Recraft's image generation with AI-Assistant for Optimizely

Recraft V3 model is outperforming all other models in the image generation space and we are happy to share: Recraft's new model is now available fo...

Luc Gosso (MVP) | Nov 8, 2024 | Syndicated blog

ExcludeDeleted(): Prevent Trashed Content from Appearing in Search Results

Introduction In Optimizely CMS, content that is moved to the trash can still appear in search results if it’s not explicitly excluded using the...

Ashish Rasal | Nov 7, 2024

CMS + CMP + Graph integration

We have just released a new package https://nuget.optimizely.com/package/?id=EPiServer.Cms.WelcomeIntegration.Graph which changes the way CMS fetch...

Bartosz Sekula | Nov 5, 2024

Block type selection doesn't work

Imagine you're trying to create a new block in a specific content area. You click the "Create" link, expecting to see a CMS modal with a list of...

Damian Smutek | Nov 4, 2024 | Syndicated blog

.NET 8 FAQ

I have previously written about .NET compatibility in general and .NET 8 in particular, see blog posts here , here and here . With the end of suppo...

Magnus Rahl | Nov 4, 2024

Dynamic packages in Commerce Connect

In Optimizely Commerce Connect, you can group different items using packages and bundles. Package: A package has one or more versions of a product...

K Khan | Nov 1, 2024