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

[Optimus]

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.

 

[Patrice]

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).