List:MySQL and .NET« Previous MessageNext Message »
From:Jordan Sparks Date:November 24 2004 6:58pm
Subject:RE: There is already an open DataReader. Bug?
View as plain text  
Did you do: dataReader.Close(); ?  You can't use a connection that has
an existing open DataReader until that DataReader is closed.  It works
the same way with MS SQL.

Jordan Sparks

-----Original Message-----
From: STI [mailto:sti@stripped] 
Sent: Wednesday, November 24, 2004 8:30 AM
To: dotnet@stripped
Subject: There is already an open DataReader. Bug?


I have a problem in my application when a try create execute the method
ExecuteScalar() in a Command when I a have a open Dataset in the same
connection! I use th MySQLClient I have the same code for Ms
SqlServer, width System.Data.SQLClient, and works fine!

How can I solve this problem? This is a Bug?

PS: The full error description is: "There is already an open DataReader
associated with this Connection which 
must be closed first"


Jorge Mota

Praça 25 de Abril 1A
2560-286 Torres Vedras
Telefone: 351 261316245 Telefax: 261316239
E-mail: jorgemota@stripped
ICQ: 144549508

There is already an open DataReader. Bug?STI24 Nov
  • RE: There is already an open DataReader. Bug?Jordan Sparks24 Nov