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

If you receive the following error message There is already an open DataReader associated with this Command which must be closed first

and you are sure that all dataReader are closed the following workaround can help you.

The MARS default settings has changed at release RC1, so multiple Result Sets are off. To turn it on only add the following string to your Connection String.

MultipleActiveResultSets=True

 


Posted Dec 07 2006, 11:40 AM by Nadine Storandt
Filed under: ,

Comments

Deepali wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 02-10-2009 6:31

Hi

Thanks

you solved my problem within min

Ashish Srivastava wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 10-14-2009 11:54

thanks

You Solve my problem  

fatemeh wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 04-05-2010 7:03

you solved my problem too

thanks

sarika wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 07-21-2010 11:45

thanks a lot

My problem get solved

sarika wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 07-21-2010 11:45

thanks a lot

My problem get solved

Malik wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 04-03-2011 10:07

Thanks it worked ...

Swarup wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 11-03-2011 11:28

This will work on server only and not on client machine. Any solution for that

Brindha wrote re: Error: There is already an open DataReader associated with this Command which must be closed first
on 01-17-2012 13:43

Thanks a lot ,it works for me.

developers.de is a .Net Community Blog powered by daenet GmbH.