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

455 · Wednesday at 5:56 PM

This error occur if you forgot to include “MultipleActiveResultSets=True” in your connection string. It was actually on by default in VS 2005 but was later set to off.

Here’s an example of a connection string w/ MARs set.

SQL Server authentication:

cnString =

"Data Source="

&

ServerName &

";Initial Catalog="

&

DatabaseName &

";Persist Security Info=True;MultipleActiveResultSets=True;User ID=sa;Password=12345678"

Windows Authentication Mode:

cnString =

"Data Source="

&

ServerName &

";Initial Catalog="

&

DatabaseName &

";Integrated Security=True;MultipleActiveResultSets=True"

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

More options

455

452,496

329,258

329,266