Subject | cannot drop table |
---|---|
Author | bill2janesoft@gmail.com |
Post date | 2008-01-08T16:15:38Z |
Hello,
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.
Any idea for how to tackle this problem will be appreciated.
bill
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.
Any idea for how to tackle this problem will be appreciated.
bill