Dmitry Arefiev

Please show the code for one "procedure SetAsGuidArray(SourceItems: TArray<TGuid>); " as an example

How pp_lfopen is defined in header file ?

TStaticText ?

uses FireDAC.Phys.ODBCWrapper; procedure TForm252.Button1Click(Sender: TObject); begin ShowMessage(TODBCConnection(FDConnection1.CliObj).DRIVER_NAME); end; https://docwiki.embarcadero.com/Libraries/Athens/en/FireDAC.Comp.Client.TFDCustomConnection.CliObj

I attached the patch. If you will fail to apply it, then please go through support. fb5_ret.patch

@VLDG, thanks ! Yes, this is the issue in FireDAC support for Firebird 5. The issue is fixed, the changes will be included into Delphi 12 Update 1.

Please report this issue to quality.embarcadero.com, if it works now ... Or just post here: a minimal test project SQL script to create DB objects steps to reproduce the issue PS: this may be a changed FB 5 behavior or a regression bug (eg, https://github.com/FirebirdSQL/firebird/issues/7774)

https://docwiki.embarcadero.com/RADStudio/Athens/en/DLL_Development_(FireDAC)

The performance issue may be resolved by replacing: // around line # 4383 CurMonitorStatus := FThreadPool.FMonitorThreadStatus; if Signaled then Continue; with: CurMonitorStatus := FThreadPool.FMonitorThreadStatus; if Signaled then begin FThreadPool.FMonitorThreadWakeEvent.ResetEvent; Continue; end;

32bit FireDAC unit tests run without problems with libpq.dll v 9.5

fd.Size := 50;

Look at http://docwiki.embarcadero.com/RADStudio/Athens/en/DBMS_Environment_Reports_(FireDAC) 1) What are the real connection parameters ? May be something is not specified correctly ... 2) What is the loaded MSSQL ODBC driver version ? May be it does not support ApplicationIntent ...

Probably ... Could you please create a new ticket at quality.embarcadero.com and provide there: 1) Simple test app reproducing the issue. 2) FireDAC environment report: http://docwiki.embarcadero.com/RADStudio/Athens/en/DBMS_Environment_Reports_(FireDAC)#Using_Delphi_Code

Support for TIMESTAMP WITH TIMEZONE and TSQLTimeStampOffsetField in FireDAC is introduced in Delphi 12.

https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Support_for_Blob_Streaming_in_FireDAC#SQL_Server_FILESTREAM https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/pathname-transact-sql?view=sql-server-ver16#return-value