Subject Re: [firebird-support] Object is in use?
Author Kjell Rilbe
Dmitry Yemanov wrote:

> Kjell Rilbe wrote:
> > When trying to drop a table I now and then get "Object XXX is in use"
> > when trying to commit. This is with FB WI-V2.1.0.17798.
> >
> > The only way I've found to resolve it is to disconnect and try again.
> What tool do you use when trying to drop a table?
> Do you have any simultaneous connections accessing that table?

Tool = FlameRobin Unicode Windows
This is a snapshot build.

No other activity on the database at all. This is on a test/development
machine and the only thing I run against the DB is FlameRobin and an ASP
(not ASP.Net) application that connects via ADO + ODBC. At the time,
there were no activity in the ASP application, although there were
active sessions. All DB activity in the ASP app happens during
server-side ASP script execution, and so, connects only when executing a
new ASP page/script, then disconnects.

I might have done DML on the table from FlameRobin, but if so, then
those transactions were committed when the drop failed.

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64