#654 ICU Problem

[Hafedh TRIMECHE]

Hello,

Please note this error:

class EZIBSQLException with message 'SQL Error: Could not find acceptable ICU library; GDS Code: 335545167; Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements 
Code: -902 Message: Connect to "Test.FDB" as user "SYSDBA"'.

Starting with the Windows 10, Microsoft natively integrated the International Components for Unicode (ICU) into the operating system.

There is no exception using 7.2.14.

constructor TEmbedConnection.Create(AOwner:TComponent);
begin
  InitUnit;
  inherited;
  LibraryLocation        := LibrarySearchPath+'fbclient.dll';
  LoginPrompt            := False;
  Protocol               := 'firebird';
  HostName               := '';
  UseMetadata            := False;
  User                   := 'SYSDBA';
  Password               := 'masterkey';
  TransactIsolationLevel := tiReadCommitted;
  AutoCommit             := True;
  ClientCodepage         := 'UTF8';
  with Properties do
  begin
    Values['isc_dpb_force_write']    := '1';
    Values['isc_dpb_set_db_charset'] := ClientCodepage;
  end;
end;

Best regards.

[marsupilami79]

Hello Hafedh,

this is a problem in Firebird. Firebird requires you to use the ICU libraries which are distributed with Firebird.
The error you get means that Firebird doesn't find these libraries. They either are removed or are not in the right location.

Best regards,

Jan