Posting again since Yahoo Groups decided to never email my post to everyone
in the group...

Thx for the replies everyone.

I'd just like to re-iterate that there is only one thread ever accessing the
datamodule and the components on the datamodule. No other thread EVER
references these components via any means, not even the main form. The only
way other threads can get data from the "database" thread is via
asynchronous thread safe Queues and Lists. The application has 12 threads
all doing different things and it all worked smoothly until I started doing
more complex queries.

As I thought, the placement of an additional TIB_Session component on the
datamodule didn't make a difference as it litteraly is only one thread ever
doing any kind of data access, hence the single internal session should be
fine. However, I did manage to get a way around this problem, here is what I
did:

Instead of having join statement which joins blob fields into the result
set, I now do multiple queries and then build the data structures locally.
This has the added benefit of less network traffic and also fixes the
problem with IBO crashing. It also speeds up the operation quite a bit since
the XML data in the blob fields are only parsed once before it is passed on
to my local data structures.

I'd still like to know what causes the problem but at least I can now carry
on with my work.

Thx for the help,
Regards,
Don


[Non-text portions of this message have been removed]