At 06:35 PM 18/06/2004 +0000, you wrote:

>The -force option for GFIX does not seem to work correctly. As a
>result, I am not able to automate the backup/restore process. I'm
>just following the procedure outlined at firebird.sourceforge.net and
>posting it here first.
>
>To reproduce the bug:
>
>- use an FB client (I used IBAccess in my test) to connect to a
>database using a user other than SYSDBA
>- from a command prompt:
>
>gfix -user "SYSDBA" -password "masterkey" -shut -force 0 <database>
>
>When GFIX completes, the database connection established in IBAccess
>can no longer do anything (expected), but when I try to perform a
>restore to the database using GBAK
>
>gbak -R -user "SYSDBA" -password "masterkey" <backup file> <database>
>
>I get:
>
>gbak: ERROR: could not drop database <database> (database might be in
>use)
>gbak: Exiting before completion due to errors
>
>If I then close IBAccess, the GBAK call succeeds.
>
>
>gfix -force does prevent new connections and it does prevent existing
>connections from doing anything. But it seems that the existing
>connection still keeps a grip on the database file.

Did you try giving it a timeout period? I'm not aware of an option to shut
down with a timeout of zero.

/heLen