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.
From: STI [mailto:sti@stripped]
Sent: Wednesday, November 24, 2004 8:30 AM
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 220.127.116.11 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"
Praça 25 de Abril 1A
2560-286 Torres Vedras
Telefone: 351 261316245 Telefax: 261316239