RE: [Firebird-net-provider] Overwrite database in use

Hi Alan,

Thanks, I know that.  May be I didn't explain well enough my question.

I have one and only one live connection.  If I close this unique
connection (myConnection.Close()) I should be able to delete the
database file in use (myDatabase.fdb), but this works only when
connection pooling is disabled.  Should I understand connection (my
unique connection) is not really closed when I call
"myConnection.Close()" and connection pooling is enabled?


Regards,
Aitor.


-----Mensaje original-----
De: Alan McDonald [mailto:al...@me...]=20
Enviado el: lunes, 30 de junio de 2003 0:30
Para: Aitor G=F3mez Gonz=E1lez
Asunto: RE: [Firebird-net-provider] Overwrite database in use


you can't do a restore with more than one live connection. It's there to
protect the database since a second connection means someone else is
currently using the DB. You can backup with many connections but
restoring is an amdin function carried out with only one connection.
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Aitor G=F3mez Gonz=E1lez
> Sent: Monday, 30 June 2003 7:29 AM
> To: Fir...@li...
> Subject: [Firebird-net-provider] Overwrite database in use
>
>
> Hi,
>
> I'm trying to overwrite database in use for a "Restore database
> backup" feature in a program, using "gbak -RESTORE_DATABASE" command.

> My code is something like this:
>
>
> myConnection.Close();
> DoRestoreDatabaseBackup();
> myConnection.Open();
>
>
> It works perfect with ConnectionPooling =3D false, but almost never =
when
> ConnectionPooling =3D true, even if "myConnection" is the only=20
> connection opened across the application.  It's not a problem for me=20
> by now, I only need a connection, I'll work without ConnectionPooling,

> but I'd like to know how could I do it in case of working with more=20
> than one connection.
>
>
> Thanks in advance,
> Aitor.
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.=20
> Download today and enter to win an XBOX or Visual Studio .NET.=20
> http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/
> 01
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider