Hello, I have a problem creating/dropping databases using isql.
OS Suse 9.1
FB SS 1.5.3
Situation: I have a PHP script that should create a database and
insert some tables, in case of failure it should drop the database.
Tables are created using SQL in a normal connection.
the command used to create and drop the database is
isql -i /path/db.sql
When the server first starts the database is created. Now say the
something goes wrong inserting the tables, dropping the database
already fails with following error message:
-901 or -902 -object <database> is in use.

This problem even remains if I wait another 1 hour before I retry to
drop the database. I could only solve this restarting the firebird
server. I think there is no need to notice that there are no other
client applications connected to the database when trying to drop it.

Can anybody help me to solve this?

Thanks in advance

Ralf