Hi,

At November 27, 2003, 09:25, Cosmin Popa wrote:

> How do I connect to a firebird database in a way to force to be the only
> connection to that database.
> I need this for making patches to my database and not see "Object is in
> use" when I issue an alter table or so.

Just to add to Martijn's comments.

Even with what Martijn mentions, it still isn't guaranteed that you
will not see "Object is in use". Depending on certain circumstances,
it can happen, even with a single connection. Although some work has
been done to alleviate the problem in FB 1.5, but it's not totally
gone. Sometimes, you'd need to disconnect after certain DDL
statements, and then reconnect again before continuing the DDL
statements(sometimes just committing the transaction is enough). I
usually had to do this when dealing with referential constraints/keys
using the same master table index(this situation might be different in
FB 1.5).

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)