RE: [Dnfbb-developers] Question

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

I have tried to keep it as close to yours as possible.  Really the only
thing I have done is modify the Fb... commands and change them to
MySql... along with putting some additional Exception handling which I
am still in the middle of implementing as you can't do it internally in
MySQL.  It works but I am not sure it is such a neat implementation at
them moment.

I will give you a shout in a while.  I will plod on and see if I can see
anything.

Cheers,

Simon

-----Original Message-----
From: dnf...@li...
[mailto:dnf...@li...]=20
Sent: 27 January 2006 17:31
To: dnf...@li...
Subject: RE: [Dnfbb-developers] Question

> -----Original Message-----
> Maybe you can help.  I seem to be stuck and can't see why. =20
> You might have had the same problem with you .net connector. =20
> If not don't worry I just thought I would ask.
>=20
> "There is already an open DataReader associated with this=20
> 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 =3D 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



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log
files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D=
121642
_______________________________________________
Dnfbb-developers mailing list
Dnf...@li...
https://lists.sourceforge.net/lists/listinfo/dnfbb-developers