Re: [Firebird-net-provider] FbCommand is currently busy Open, Fetching.

[<car...@te...>]

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