At 10:23 AM 10/02/2006, you wrote:

>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?

Well, a DDL script is nothing but a batch of SQL requests. It's not
a program. So if you have a problem with a request, such as create
table, you will need to take care of committing or rolling back the
transaction. The engine isn't going to let you drop the database if
there is a pending transaction waiting for attention.

Ask on the firebird-php for help with your php script to monitor and
respond to exceptions being returned duing execution of an isql
command. Someone is sure to have done this already...

./heLen