Subject RE: [firebird-support] Re: Attempting Recovery With Services API
Author Alan McDonald
> --- 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.
Alan