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 Beha=
lf 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 b=
ackup"
> > 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 nev=
er when
> > ConnectionPooling =3D true, even if "myConnection" is the only co=
nnection
> > 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 l=
ike to
> > know how could I do it in case of working with more than one conn=
ection.
> >
> >
> > Thanks in advance,
> > Aitor.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: Free pre-built ASP.NET sites incl=
uding
> > 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_06120=
3_01/01
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provide=
r