RE: [Dnfbb-developers] Question

[<dnf...@li...>]

> -----Original Message-----
> Maybe you can help.  I seem to be stuck and can't see why.  
> You might have had the same problem with you .net connector.  
> If not don't worry I just thought I would ask.
> 
> "There is already an open DataReader associated with this 
> Connection which must be closed first."

Are you explicitly closing all DataReaders?  I have had this problem with
the firebird .net driver, if I don't explicityly close the data reader and
commit/rollback transactions.  Something like:


FbDataReader rdr = cmd.ExecuteReader();
try
{
	while (rdr.Read())
	{
		//do something
	}
}
finally
{
	rdr.Close();
}

If you havn't solved it in the next few hours, let me know and I will
install a MySQL board and have a look.

Rgds

Si