Commented by: Tim Kelly (m00bh000)

WI-V3.0.0.32076 Does not contain this bug

Not sure about versions in-between, don't have them.

Commented by: Tim Kelly (m00bh000)

Ensure you rename fbclient.dll to gds32.dll and place is correct folder
If run in debugger be sure to make sure current path only contains one possible gds32.dll. (32bit version) or you will have trouble getting it to use the right file!

Commented by: Tim Kelly (m00bh000)

I have now included a simple test case so this bug can hopefully be fixed. It appears to be a threading issue.

Commented by: @dyemanov

Please attach (or send via email) the compiled binary for the test. I have no Delphi to compile it.

Commented by: @dyemanov

Also, do you use local (hostless) or remote (including host name) connection string?

Commented by: Tim Kelly (m00bh000)

I use a remote connection string (you can set it in the test app).

It seems that the problem is in the client as I just ran the newer fbclient.dll against the older server and it has the problem.

Binaries attached.

Commented by: Tim Kelly (m00bh000)

You may be able to reproduce this problem in C. The test thread is very simple, once you get to about 20 con-current threads you start hitting the problem:

THREAD FUNCTION:

for I := 0 to 10000 do
begin
transaction.StartTransaction;
query.SQL.Text := 'SELECT X FROM A';

try
query\.Open;
query\.Close;
except
  on E: Exception
  do
  begin
    Application\.ShowException\(E\);
  end;
end;
transaction\.Commit;

end;

Commented by: Evelyne Girard (evelyne)

I experiment the same error "Invalid statement handle" with Firebird 2.5.4 (server x64, client x32) ... in similar circumstances (a secondary thread). Could it be the same problem, and if so, is there a fix ?