Subject Re: [firebird-support] Object is in use?
Author Milan Babuskov
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.

Maybe you could query the monitoring tables when the problem appears and
see what might be 'using' the object?

Milan Babuskov