> > I am using FBLib Firbird Library v0.85
> > http://fblib.altervista.org/
> >
> > It is a Borland Packaged Library (.bpl) of classes that call isc_
> > functions
> > in gds32.dll.
> >
> > I disconnect from the database and then free the database object:
> > if (db <> nil) and db.Connected then
> > begin
> > db_name := db.DBFile;
> > db.DBFile := '';
> > db.Disconnect;
> > db_service.GFixSetShutDownDb(db_name, 1);
> > Sleep(1500); // Wait a little for the db to shut down
> > FreeAndNil(db);
> > end
> > [...]
>
> I don't use this lib. I use IBO exclusively. So I can't offer
> experience in
> the use if these calls.
> I see, though, that the Destroy procedure also disconnects from the
> service
> manager, which suggests that a connection makes this attachment by
> default.
> Also not sure about the shutdown logic here (above).
> I never shut my databases down (using embedded). Doesn't make sense
> since
> you are the only connection anyway. But the shutdown itself requires a
> persistent connection to ensure no new connections are established. So
> where
> is the logic in all this?
> Alan
>
>
>
> Well I am now thinking I also use IBExpert as a GUI for my database for
> testing,
> and I do not remember IBExpert having this problem ... Maybe it is
> indeed
> FBLib;
> now I am not even sure ! I shortly looked over the connect sequence in
> FBLib
> and I saw no file being opened though .... I will have to check again
> IBExpert and
> FBLib.
>
> The shut down and service manager connection I have only recently added
> in
> my
> code hoping that this will have some effect and close the (FBLib ?)
> handles
> on the
> database files.
>
> Thank you,
> Timothy Madden,
> Romania

maybe helen can shed some more light on this, but I think you're asking the
services manager to manage a DB shutdown which can't complete until all
connections are dropped. So you're defeating your purpose. Leave the whole
idea of shutdown out of the equation for the moment.
Alan


My problem happens with or without the call to service manager for db
shutdown.
And I am using gfix -force 1 -shut dbFile, that is I am doing a forced
shutdown.
And by the time I call shutdown my connection to db is already closed ...
I will remove the service manager and shutdown call since it does not seam
related to my problem anyway.

Timothy Madden
Romania


[Non-text portions of this message have been removed]