There is already an open DataReader associated with this connection
Posted by: Kostas Dakanalis
Date: September 23, 2006 01:59AM

Hi everyone
Reading this article http://bugs.mysql.com/bug.php?id=7248 about the ExecuteReader and ExecuteNonReader i wonder how can we solve this problem .
When a DataReader is Open you canot Execute any SQL command from the same connection .
In the ADO.NET i can open as many Recordsets i want and while the recordsets are open i can execute from the ADODB.connection any SQL command i want .
This is usefull in case someone wants to select different data and insert records in other tables .
I want to ask in this case the only way is to have two connections opened , one for Reading Data and one for Executing SQL commands ?
Do we have to wait something new about RecordSets in Mysql in the future ?

Thanks .

Options: ReplyQuote


Subject
Written By
Posted
There is already an open DataReader associated with this connection
September 23, 2006 01:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.