468,554 Members | 1,863 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,554 developers. It's quick & easy.

I've got doubt about MARS feature support in ASP.NET 2.0 and MSSQL 2.0

Hi everyone,

I've got issue about MARS feature support in ASP.NET 2.0 and MSSQL 2.0
How to get things work?

What i've done is I got vs.net 2.0 and MSSQL 2005 installed on my pc.
Then I tried to test MARS feature following the example in the msdn
website
as the url "http://msdn2.microsoft.com/en-us/library/yf1a7f4f"
to see what the asp.net 2.0 can do with multiple active result sets.

What the code should be doing is to instantiate two instances of
datareader.
Then it will execute the datareader#1 and loop through the first result
set returned.
after that inside the datareader#1's block, the code will get the
datareader#2 executed and retrieve its own result sets while the first
datareader's retrieving operation is not completed.

When running the code,I still got the error "There is already an open
DataReader associated with this Command which must be closed first."
which is the same error I should encounter with the older version of
ASP.NET.

Because it should work fine as long as I got everything installed
correctly.

Nov 19 '05 #1
1 1293
Not enabled in the connection string ?

You mention SQL Server 2005 but also MSSQL 2.0 (do you mean 2000 ?). Which
version are you using ? If you have both double check you are trying against
SQL Server 2005 (from the previous page it looks like you need SQL Server
2005).

--
Patrice

"Optimus" <sa******@gmail.com> a écrit dans le message de
news:11**********************@o13g2000cwo.googlegr oups.com...
Hi everyone,

I've got issue about MARS feature support in ASP.NET 2.0 and MSSQL 2.0
How to get things work?

What i've done is I got vs.net 2.0 and MSSQL 2005 installed on my pc.
Then I tried to test MARS feature following the example in the msdn
website
as the url "http://msdn2.microsoft.com/en-us/library/yf1a7f4f"
to see what the asp.net 2.0 can do with multiple active result sets.

What the code should be doing is to instantiate two instances of
datareader.
Then it will execute the datareader#1 and loop through the first result
set returned.
after that inside the datareader#1's block, the code will get the
datareader#2 executed and retrieve its own result sets while the first
datareader's retrieving operation is not completed.

When running the code,I still got the error "There is already an open
DataReader associated with this Command which must be closed first."
which is the same error I should encounter with the older version of
ASP.NET.

Because it should work fine as long as I got everything installed
correctly.

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by mj | last post: by
198 posts views Thread by Michael N. Christoff | last post: by
8 posts views Thread by HalcyonWild | last post: by
11 posts views Thread by krishnamaddi | last post: by
33 posts views Thread by jacob navia | last post: by
11 posts views Thread by whirlwindkevin | last post: by
32 posts views Thread by jhc0033 | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.