Dmitry Arefiev

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

Thanks, fixed.

Sorry, poetry.

1 hour ago, Anders Melander said:

I would agree but he said that he:

 

Doesn't closing the connection also close all open cursors associated with the connection?

Yes, it is. But we are talking about "poesie", not about the "code" ...

IMO, this was fixed after 10.3. So, upgrade ...

There are two basic options:

1. Set FetchOptions.Mode=fmAll
2. Use MARS

TFDTable.CreateTable