Subject RE: [firebird-php] Problem creating tables
Author Alan McDonald
> Hello all,
> I have a problem creating tables from a php script. I'm using FB SS
> 1.5.3 on Suse 9.1.
> The script should create a database with around 30 tables. To do that
> I use ADODB datadict. In case something goes wrong, the database
> should be deleted.
> Creation of the database works fine. The creation of the tables fails.
> It just creates around 5 tables but the script returns success code on
> the creation of all tables. After the creation of the tables some
> grants and some data should be inserted, and this fails. Because of
> this failure the script now should drop the database, which doesn't
> work any more, isql returns -901 -object <database> is in use. This
> even remains after minutes or hours of waiting. The only way to get
> dropping to work is restarting the firebird server. There are no other
> clients connected to the server.
> It seems that the server is still caught in the process of creating
> the tables.
> Any ideas where the problem could come from?
> Best regards
> Ralf

are you specifically committing the transaction(s)?
do you commit the transaction after table creation and before data
insertion? then start another transaction?
do you use connect() or pconnect()?
do you specifically close the connection?
maybe we should see the script