RE: [Firebird-net-provider] connection to interbase

[Mike N. <Mi...@ta...>]

Hi

I think you need to have a transaction associated with your command.

FbTransaction MyTransaction;
MyTransaction = cn.BeginTransaction;

try
{
... try your SQL here...
MyTransaction.Commit();
}
catch 
{
MyTransaction.Rollback();
}


Mike






<SNIP>

IDbConnection cn = new FirebirdSql.Data.Firebird.FbConnection(conString) ;

cn.Open() ;

IDbCommand dbcmd = cn.CreateCommand() ;

dbcmd.CommandText="select * from mcust" ;

Console.WriteLine(cn.State.ToString()); // gives back OPEN

dbcmd.ExecuteReader() ;  //  <----------  Here it crashes!!! error: Command
must have a valid transaction