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

[Vinnie <no...@sp...>]

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 th 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



<vin...@pr...> wrote in message
news:200...@ms......
> Hi all,
>
> I have to make a connection to an interbase 6.0 server from
> an C# application.  I have no experience with interbase so
> you can treat me a a beginner :)
>
> I downloaded the FirebirdNETProvider1.5-RC3-NET1.1.exe file
> but it gives an error when I try to install.
>
> All help and sample code on the best way to connect to an
> interbase server from a .net application is welcome.
>
> Im have to get this program finished by friday so Im kinda
> doing a nightshift here :)
>
>
>
> Greets,
>
>
> Vincent Locquet
> Produmex
>
>
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>