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?
Hello,
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 1.0.0.2 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"
Tia,
Jorge Mota
Praça 25 de Abril 1A
2560-286 Torres Vedras
Portugal
Telefone: 351 261316245 Telefax: 261316239
E-mail: jorgemota@stripped
ICQ: 144549508
