--- In ib-support@yahoogroups.com, "Datatal AB - Gauffin, Jonas"
<jonas@d...> wrote:

> Hello
>
> I'm writing a small test application for firebird that uses Open
> FireBird ODBC Driver.
> Everything works nice when I got one connection.
> But as soon as I load up more threads, with one connection each,
> everything stops in the execution of a sql statement (SELECT
> GEN_ID(GEN_USER, 1) FROM RDB$DATABASE).
>
> I've started with a thread that do random reads and a thread that do
> random inserts/updates.

[skip]

> What can be wrong?

Jonas, I don't know C, but I could'nt find in your text
a) connection string - local connections are queued in gds32 so you
threads will wait each other.
b) transaction parameters - some modes produce infinitive waiting on
lock conflict resolution with random tests.

Best regards, Alexander V.Nevsky.