--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:

>
> > --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@>
> > wrote:
> > >
> > > > > inoffensive_2009 wrote:
> > > > > > Firebird 2.1.1 Embedded, recient IBPP.
> > > > > >
> > > > > > I'm a big fan of IBPP, but for reasons I don't understand I
> > > > can't
> > > > > > get any traction with it when the task is recovering a
> > database.
> > > > > >
> > > > > > Oliver spelled it out for me:
> > > > > >
> > > > > > svc = ServiceFactory()
> > > > > > svc->Connect()
> > > > > > svc->shutdown()
> > > > > > svc->StartRestore)
> > > > > > svc->Disconnect()
> > > > >
> > > > > No need to shutdown the embedded. Just disconnect from database
> > and
> > > > > you'll be fine.
> > > >
> > > > Thanks Milan and Alan:
> > > >
> > > > Disconnect!
> > > >
> > > > Yikes!
> > > >
> > > > That's what was causing my problems, I forgot to disconnect!
> > > >
> > > > In order to make my backup function work on embedded and
> > > > client-server environments, I'll keep the shutdown.
> > > >
> > > > Thanks for showing me my mistake.
> > > >
> > > > Larry
> > >
> > > do you know what shutdown does?
> >
> > Thanks again Alan:
> >
> > The InterBase documentaion says isc_spb_prp_shutdown_db "Shuts down
> > the database".
> >
> > IBPP's reference for the Service interface says Shutdown() is "Used
> > to shutdown a database. Shutting down a database consists of properly
> > denying connections from other users than the SYSDBA or owner user"
> >
> > I'm sure mine is a shallow understanding.
> >
> > > I'm pretty sure it's not what you think.
> >
> > You're probably right. But I'm interested in understanding more.
> >
> > Thanks
> > Larry
>
> denying future connections offers no control over existing connections.

Thanks again Alan:

I'm trying to understand the implications of that statement.

Does this mean a user can prevent a shutdown by refusing to
disconnect?

Larry