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