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

Sorry if I misunderstood..
I imagine that with connection pooling turned on, then there are other
connections made by the driver at the time you make your single connection.
With connection pooling turned on, there is also the timeout to consider on
connection made, not used and expired...

Alan

> -----Original Message-----
> From: Aitor Gómez González [mailto:ait...@gm...]
> Sent: Monday, 30 June 2003 9:13 AM
> To: 'Alan McDonald'
> Subject: 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...]
> Enviado el: lunes, 30 de junio de 2003 0:30
> Para: Aitor Gómez González
> 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ómez González
> > 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 = false, but almost never when
>
> > ConnectionPooling = true, even if "myConnection" is the only
> > connection opened across the application.  It's not a problem for me
> > 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
> > 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.
> > Download today and enter to win an XBOX or Visual Studio .NET.
> > 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
>
>