Commented by: Daniele Allegretti (mktsrl)

I have found this problem with Delphi6, DBExpress and Firebird 2.1.0.17798 Engine.
But I believe that this is not a problem of Firebird engine but a problem of the DLL client fbclient.dll.

I think this beacause if I use fbclient.dll of versione 2.0.4 (with engine 2.1.0) Delphi works correctly, instead if i use fbclient of 2.1.0 (with engine 2.1.0) pop-up the error "Error mapping failed" on first "SELECT" query.

Also with Embedded version 2.1.0 (fbembed.dll version 2.1.0.17798 renamed as GDS32.DLL) Delphi 6 works correcly.

Buon lavoro
Daniele Allegretti
MKT SRL
Italy

Commented by: Daniele Allegretti (mktsrl)

Another information about this bug:
the problem there is only with remote (TCP) database connection and not with local connection.
For example this connection do error
Database := 127.0.0.1:C:\DEMO.FDB
and this no
Database := C:\DEMO.FDB

I upload a little project (with compiled exe) that generate 100% this error.

Thanks
Daniele Allegretti

Commented by: Daniele Allegretti (mktsrl)

Another information about this bug (WITH FILE UPLOADED):
the problem there is only with remote (TCP) database connection and not with local connection.
For example this connection do error
Database := 127.0.0.1:C:\DEMO.FDB
and this no
Database := C:\DEMO.FDB

I upload a little project (with compiled exe) that generate 100% this error.

Thanks
Daniele Allegretti

[ Show » ] Daniele Allegretti - [21/May/08 03:54 AM ] Another information about this bug: the problem there is only with remote (TCP) database connection and not with local connection. For example this connection do error Database := 127.0.0.1:C:\DEMO.FDB and this no Database := C:\DEMO.FDB I upload a little project (with compiled exe) that generate 100% this error.

Thanks
Daniele Allegretti

Commented by: @dyemanov

Actually, the issue is inside Borland's DBX driver for InterBase. It's not very much compatible with Firebird. First of all, it uses some internal (metadata) queries in the syntax FB dislikes, thus causing an error. Second, it seems to handle the API errors improperly and this is exactly the difference between FB v2.0 and v2.1. If you'd try e.g. the Upscene DBX driver for Firebird, you'd notice that all test cases work correctly with both FB v2.0 and v2.1. As for the Borland's driver, the only suggestion I have is to turn off the "Get Metadata" property of TSQLDataSet.