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

It may not be in conformance but maybe there should be a parameter in=
 the
connection string to force a single connection even when the pooling =
on the
driver is set to ON.
I would never have thought to or wanted to do a restore via the old O=
DBC
connection setup and I suppose the .NET driver has some left over log=
ic
assocated with this kind of connection
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf=
 Of
> Alan McDonald
> Sent: Monday, 30 June 2003 11:23 AM
> To: Aitor G=F3mez Gonz=E1lez; Fir...@li...urcefor=
ge.net
> Subject: RE: [Firebird-net-provider] Overwrite database in use
>
>
> Sorry if I misunderstood..
> I imagine that with connection pooling turned on, then there are ot=
her
> 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=F3mez Gonz=E1lez [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 ques=
tion.
> >
> > 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=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 t=
here 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 connecti=
on.
> > Alan
> >
> > > -----Original Message-----
> > > From: fir...@li...
> > > [mailto:fir...@li...]On Be=
half 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" co=
mmand.
> >
> > > My code is something like this:
> > >
> > >
> > > myConnection.Close();
> > > DoRestoreDatabaseBackup();
> > > myConnection.Open();
> > >
> > >
> > > It works perfect with ConnectionPooling =3D false, but almost n=
ever when
> >
> > > ConnectionPooling =3D true, even if "myConnection" is the only
> > > connection opened across the application.  It's not a problem f=
or me
> > > by now, I only need a connection, I'll work without ConnectionP=
ooling,
> >
> > > 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 in=
cluding
> >
> > > 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_061=
203_01/
> > > 01
> > > _______________________________________________
> > > Firebird-net-provider mailing list
> > > Fir...@li...
> > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provi=
der
> >
> >
>
>
>
>
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites includ=
ing
> 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