Hello:
> I'm getting this error:
> when I'm trying to run this code: FbCommand is currently busy Open,
> Fetching.
>
> cnn.Open();
> FbTransaction trans = cnn.BeginTransaction();
> cmd = new FbCommand("SELECT USER_PASSWORD FROM USERS WHERE USER_NAME='" +
> uid + "'",cnn,trans);
> dr = cmd.ExecuteReader();
> trans.Commit();
> cnn.Close();
>
> Anybody got an idea what i'm doing wrong?
This exception gives when you try to use the FbTransaction class and the
connection
has an open DataReader, try this:
cnn.Open();
FbTransaction trans = cnn.BeginTransaction();
cmd = new FbCommand("SELECT USER_PASSWORD FROM USERS WHERE USER_NAME='" +
uid + "'",cnn,trans);
dr = cmd.ExecuteReader();
dr.Close(); <--------------------
trans.Commit();
cnn.Close();
--
Best regards
Carlos Guzmán álvarez
Vigo-Spain
|
