--- In firebird-support@yahoogroups.com, "robertgilland"
<robert_gilland@...> wrote:

>
> I am using the IboAdmin components to shut down the database.
> with the below code ( Delphi 7 ).
>
> try
> ibConfig.Active := TRUE;
> ibCOnfig.ShutdownDatabase(Forced,spnWaitfor.Value);
> while IBConfig.IsServiceRunning do
> begin
> Sleep(10);
> Application.ProcessMessages;
> end;
> ibConfig.Active := FALSE;
> except
> on E:Exception do
> ShowMessage(E.Message);
> end;
>
> However after I call this procedure, I then try to rename the
> GDB file. I cannot the server is still connected to it.
> I thought calling shut down would kick off all attachments
> to the database. It seems it does not.

It does not kick off the SYSDBA or OWNER users, so if you are
connected as them then this will not work. The garbage collection
thread may still be active for a few seconds, how long do you give it
before attempting to rename the file?

Adam