Subject Re: [firebird-support] Firebird ODBC driver thread safe?
Author Kjell Rilbe
Helen Borrie wrote:
> Not strange at all. The local IPServer is not thread-safe. It emulates a
> network connection by sharing IPC space between the client library and the
> server. If you try to multi-thread in this space, you have objects
> trampling all over one another's space.
>
> Use TCP/IP local loopback if you are going to create multiple instances of
> your local connection object. (Well, use local loopback *anyway*! Leave
> IPServer for embedded applications like gbak, gsec and isql; and for
> embedded server applications.)

Aha! So the ODBC driver (if I look at it like a black box) is
thread-safe for TCP/IP connections but not for local connections. So I
have to write localhost:<path> to connect to a local database in a
thread-safe way. Is this what you're saying?

Adding "localhost:" in the ODBC driver settings seems to have solved the
problem. THANKS!!!!

> Btw, you should take ODBC questions to the appropriate list
> (firebird-odbc-devel).

Right - din't think of that. I will, next time.

Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64