Firebird 5.0 with dbExpress (Delphi 12): unknown ISC error 0

[Achim Kalwa 61]

Hello *,

 

our application still uses Firebird 3.0.x with dbExpress for data access. We would like to use Firebird 5.0 in the near future. Some first tests throws an exception "unknown ISC error 0" when executing this simple SQL query:

select * from MON$DATABASE

Looks like dbExpress can't handle the new "TIMESTAMP WITH TIMEZONE" data type. Is there any switch or parameter to make dbExpress work with Firebird 5? Or do we need to change all the code to use FireDAC?

 

TIA

Achim

 

[Lajos Juhász 293]

22 minutes ago, Achim Kalwa said:

Looks like dbExpress can't handle the new "TIMESTAMP WITH TIMEZONE" data type. Is there any switch or parameter to make dbExpress work with Firebird 5? Or do we need to change all the code to use FireDAC?

 

You can try to contact support and ask to open a ticket for dbExpress. As you wrote this is a new feature in Firebird that should be supported.

[FredS 138]

3 hours ago, Achim Kalwa said:

can't handle the new "TIMESTAMP WITH TIMEZONE" data type

You can execute this statement after connecting to a v4 or v5 db:

'set bind of TIME ZONE to LEGACY'

 

[Achim Kalwa 61]

9 minutes ago, FredS said:

You can execute this statement after connecting to a v4 or v5 db:

'set bind of TIME ZONE to LEGACY'

Thanks a lot; I will try that.