--- In ib-support@y..., "Claudio Valderrama C." <cvalde@u...> wrote:

> ""the_k_dubb"" <kevin@w...> wrote in message
> news:a2k9f3+pf1k@e...
> > I have tried everything to rid myself of this error, and I

cannot. I

> > am trying to create tables from my application as it needs them.

What

> > I am experiencing is that after a table has been used in a query,
> > creating foreign keys, or dropping foreign keys to that table is
> > unreliable at best.
>
> > I have even gone so far as to disconnect and reconnect
> > my connection before trying to alter the keys. I still receive the
> > object in use errors, are there any other suggestions?
>
> This is not the point. From the engine pov's, what counts is that

the db is

> detached and unloaded. This only can be achieved if NO connection

is held to

> the db, whether yours or from another user. All connections should

be

> terminated. Most GUI programs create more than one connection to

work so

> they trick the user thinking that there're phantom connections.
>

I didn't make my situation clear enough, I am using the C API and I
have only a single process attaching to the db, and only a single
connection from that process. I used to use multiple connections, and
I thought that was the reason for the error, but now that I have
switched to a single connection it still exhibits the same problems.