Re: [Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi Carlos,

This has worked brilliantly, I am now able to delete the file after running
my dot net code. Thank you.


This particular problem has brought up the issue of the benefits of using
connection pooling on a firebird db.
If say I had a busy website using a firebird db as a back end, that was
using connection pooling and was visited by a fair amont of people.
Then supposing I needed to take the website down for a short period of time,
say for routine maintenance, I would have a whole pile of open connections
in my database.
I guess that I would need to close the connections gracefully, I'm not sure
how I would do this.

This situation could arise if say a problem arose on my production site and
I wanted to shut my production site down for a while and copy the production
database to my development server, Firstly stoping the firebird service on
the production server. Stopping the service would report "Overlapping I/O
operation."

anyway, I know the above is not a .net question and probably hightlights my
limited understanding of firebird, it's just got me wondering, that all.

Thanks agian for helping me out.

cheers

martin.





"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > Is connection pooling just turned on in the connection string or is
there a
> > .net setting to do this.
>
> This is done using the connection string:
>
> Pooling=false
>
> Try this and comment the results please :):
>
> <add key="DbConnectionString"
>
value="Database=C:\\Inetpub\\wwwroot\\NZ\\_database\\RESTOREDB.GDB;User=SYSD
BA;
> Password=masterkey;Dialect=3;Server=localhost;Pooling=false"/>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>