firebird-net-provider

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

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

[<vin...@pr...>]

Hi, some updates on my progress so far...

I installed the 1.0 version for .net framework 1.1 
succesfully.

I am able to make connection to the server. I get the 
string "open" back wen
I ask the connection.state.
So far so good but I can not run a command.

I get the following error back:
Command must have a valid transaction

the sql statement is 100% correct....
See code below to see what Im doing.
What could be wrong?


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