--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> I'm reliably informed that libfbclient.so can be used for multi-

threading

> connections to Fb 1.5 Classic servers on either Windows or Linux,

though I

> haven't tried it myself.

Is it safe to use the same database connection across multiple
threads in a Windows client app using the superserver? This was
working when I was using the embedded server.

When I switched from the embedded server to the superserver, I have
an exception thrown that I wasn't getting before. Just switching
back to the embedded server (and removing "localhost:" from the
connect string), I don't see the error. I'm convinced it has to do
with the change of Firebrid server model. It is a single Windows app
running, but it is multi-threaded. Both threads use the same
database connection.

It appears to be some sort of re-entrance problem and I'm thinking
perhaps each thread must use it's own database connection. But if I
do, will there be caching issues (i.e. thread 1 writes data that
thread 2 doesn't see until buffers are flushed).

Note: I'm still trying to find a way to run multiple client apps plus
superserver on the same box without using TCP/IP and wondering if
named pipes is the way to go.

Joe A.