Dmitry Arefiev

This is about Firebird, but is equally applicable to InterBase: https://www.firebirdfaq.org/faq29/

InterBase does not support "AUTO_INCREMENT".

TStringHelper appeared in System.SysUtils in XE3. From beginning it had Split method.

What is the Delphi version ?

Please, show your code to query meta-data

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

On Win7 the same code returns status 200. May be something related to WinHttp settings ? If you want, you can try to mimic Firefox more, at least by adding the headers, which it sends by default ?

Android HttpURLConnection converts GET to POST when there is a request body: https://stackoverflow.com/questions/8760052/httpurlconnection-sends-a-post-request-even-though-httpcon-setrequestmethodget

A lot depends on a resource, which you are trying to authenticate. What is it (hopefully some publicly available) ?

If something is freezing, then it is not good. Please report to QP, all together with original issue.

I am not sure, but try to set ResourceOptions.DirectExecute to True