bill2janesoft@... wrote:

>
> I created a table dynamically and inserted some rows and then read them. Then I
> freed that statment handle. When I tried to drop that table, it raised an error:
>
> HY000 _607 [ODBC Firebird Driver][Firebird]unsuccessful metadata update object
> TPTABLE2356254 is in use
>
> I use direct odbc api call, and
> one connection handle (A) to create and fill the rows
> another connection handle (B) to read the rows, statement handle for reading was
> freed.
> both handles did not issue any transaction and lived for ever. I used connection
> handle (A) to drop the table.
>

If connection B has used the table, you can't drop it until B exits.

Regards,


Ann