At 02:54 PM 9/05/2005 -0500, you wrote:

>Helen Borrie wrote:
> >
> > There are a few things...
>
>Thanks for the help! It looks like a combination of your suggestions 2,
>3, 4,
>and 9 fixed the problem. The big thing seems to be creating one TIB_Session
>in the main thread for all the client connections. I also switched to the
>full server since your reply and most info I find on the FB newsgroups
>implies
>the embedded server isn't terribly thread-safe.

Revise that to "isn't thread-safe at all". That will change with Firebird
2 and the replacement of the IPServer hack with a proper local protocol
built on the XNET subsystem.

In short, if you need to multi-thread an app that connects locally, DON'T
user the current FbEmbedded (or IPServer with the full server). Use
Classic or Superserver full server and connect through localhost.

Helen