Subject | Firebird ODBC driver thread safe? |
---|---|
Author | Kjell Rilbe |
Post date | 2005-02-23T10:29:43Z |
Is the Firebird ODBC driver thread safe?
I'm asking because I'm seing some strange behavior here...
What I'm doing is this (Delphi 7, Win2000):
1. Create a TThread (a descendant of course).
2. In TThread.Execute:
2.1. Create a TADOConnection that connects to a local Firebird 1.5.2
superserver via ODBC, and open it.
2.2. Create a TADODataSet using the new connection and open it. The
query takes a minute or two to execute.
3. While the first query executes, repeat steps 1-2.2 for a second query
(new TThread, new TADOConnection, new TADODataSet).
What happens is that neither query seems to ever return. In other words,
the TADODataSet.Open calls never return. I've waited until the fbserver
process stops using up a lot of CPU + several minutes.
It works fine if I only run a single query.
Any ideas?
Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
I'm asking because I'm seing some strange behavior here...
What I'm doing is this (Delphi 7, Win2000):
1. Create a TThread (a descendant of course).
2. In TThread.Execute:
2.1. Create a TADOConnection that connects to a local Firebird 1.5.2
superserver via ODBC, and open it.
2.2. Create a TADODataSet using the new connection and open it. The
query takes a minute or two to execute.
3. While the first query executes, repeat steps 1-2.2 for a second query
(new TThread, new TADOConnection, new TADODataSet).
What happens is that neither query seems to ever return. In other words,
the TADODataSet.Open calls never return. I've waited until the fbserver
process stops using up a lot of CPU + several minutes.
It works fine if I only run a single query.
Any ideas?
Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64