Errors on Chapter 12 example(12.8)

sonnie · #1 (**permalink**) December 28th, 2005, 10:05 PM

Dear Friends,

I'm getting error on chapter 12(List 12.8). Is there any one who is able to compile that one successfully. Error is:
"
Line: OrderDetailReader = Command.ExecuteReader();

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

Thanx
Sonnie

terry hutt · #2 (**permalink**) May 31st, 2006, 12:56 PM

Quote:

quote:Originally posted by sonnie
Dear Friends,

I'm getting error on chapter 12(List 12.8). Is there any one who is able to compile that one successfully. Error is:
"
Line: OrderDetailReader = Command.ExecuteReader();

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

Thanx
Sonnie

I'm getting exactly the same problem. The whole purpose of this example is to show how to have multiple data readers open on the same connection WITHOUT getting this error message.

terry hutt · #3 (**permalink**) June 7th, 2006, 10:55 AM

I figured it out from an article about MARS on MSDN.
http://msdn2.microsoft.com/en-us/library/h32h3abf.aspx.
You need to append the following to your connection string...
MultipleActiveResultSets=true

If the book actually contained the connections string the examples required it would help greatly. This is one of the areas n which the book needs to be improved.

Need to download code?

Navigation