Re: [Firebird-net-provider] FirebirdNET Provider 1.6 Beta 1 Exception

[Gianfranco G. <ggi...@se...>]

Carlos your example works for me too.

The "Connection lifetime=15" is the cause. The Connection is destroyed and
an Exception is raised because the Connection Object = null. For that if I
ReOpen de Connection everything works fine.

But in the 1.5.2 version the behavior was different.

If i'm wrong let me know.

Kind Regards
Gianfranco


"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:406...@te......
> Hello:
>
> > The problem was that in the FbConnection object the Open method now it's
> > required.
>
> Are you sure ?? this sample works for me:
>
> FbConnection connection = new FbConnection(connectionString);
>
> string sql = "SELECT * FROM PROJECTS";
>
> FbDataAdapter adapter = new FbDataAdapter(sql, connection);
> FbCommandBuilder builder = new FbCommandBuilder(adapter);
>
> FbCommand i = builder.GetInsertCommand();
> FbCommand d = builder.GetDeleteCommand();
> FbCommand u = builder.GetUpdateCommand();
>
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>