Jump to content

Dmitry Arefiev

  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Dmitry Arefiev

  1. Dmitry Arefiev

    Check for override

    Could you please provide some tickets to better understand what and where.
  2. https://www.wireshark.org/ https://www.telerik.com/fiddler
  3. In this case I would try to capture HTTP packets sent from 10.1.2 and 10.2.1 clients. And will try to understand what is the difference between them, which may lead to this failure ...
  4. This is not related to REST client. But is related to REST server, which is accessing to InterBase server. And due to some reason the database specified in FireDAC connection parameters is not available. Start from checking your InterBase interbase.log ...
  5. Dmitry Arefiev

    Erro 10.3.1 java.lang.IllegalStateException

    The patch and instruction is published there: https://quality.embarcadero.com/browse/RSP-23656
  6. Dmitry Arefiev

    Please faster json library

    @RDPasqua, depends on RAD Studio version. In 10.3 standard JSON library is much faster and reliable.
  7. Dmitry Arefiev

    Improve speed in IDE

    This issue is fixed in 10.3 Rio. And more is comming in Updates. If to stay with 10.1, then search and install IDE HotFix Pack.
  8. Dmitry Arefiev

    SQLBindParameter error with TFDQuery / ODBC

    https://quality.embarcadero.com/browse/RSP-20857 Will be fixed in 10.3 Update 1
  9. Dmitry Arefiev

    Firedac and SQL Server DB with "." in name

  10. No sense, as in the trial to find 100% working guessing
  11. It is impossible to decide for 100%. But possible to guess taking into account ThousandSeparator and DecimalSeparator. It will work in 95.38% of the cases. All other - up to the user.
  12. Dmitry Arefiev

    General DB access question -- paging query results

    Oracle 12 extended maximum length of VARCHAR2 to 32Kb. And there always was LONG. CLOB / BLOB are stored in tablespaces. BFILE are stored in external files.
  13. Dmitry Arefiev

    Firedac and PostGreSQL Over SSL

    You need to use sslxxxx PostgreSQL connection parameters: https://www.postgresql.org/docs/11/libpq-connect.html#LIBPQ-PARAMKEYWORDS And put them into FireDAC PGAdvanced connection parameter: http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Connect_to_PostgreSQL_(FireDAC)#Connection_Definition_Parameters
  14. Dmitry Arefiev

    ISAPI in Delphi 10.2,10.3 TranslateURI

    Instead of last "Size" reference there should be "Size - 1". Fixed.
  15. Dmitry Arefiev

    Rio SOAP gzip response problem

    @ihx, please, report this issue to https://quality.embarcadero.com
  16. Dmitry Arefiev

    Rio SOAP gzip response problem

    1) This is worth to report, but rather as a feature request. Support for automatic decoding may be done easily using WinHTTP WINHTTP_OPTION_DECOMPRESSION option. And probably already in 10.3 Update 1. As a quick workaround, you can modify System.Net.HttpClient.Win.pas, for example: function TWinHTTPClient.DoExecuteRequest(const ARequest: THTTPRequest; var AResponse: THTTPResponse; const AContentStream: TStream): TWinHTTPClient.TExecutionResult; begin ..... // Enable automatic decoding LOptionValue := WINHTTP_DECOMPRESSION_FLAG_GZIP or WINHTTP_DECOMPRESSION_FLAG_DEFLATE or WINHTTP_DECOMPRESSION_FLAG_ALL; WinHttpSetOption(LRequest.FWRequest, WINHTTP_OPTION_DECOMPRESSION, @LOptionValue, sizeof(LOptionValue)); .... end; 2) THTTPReqResp was using WinINet API directly. In 10.3 it was completely reworked to enable support of other platforms, including Linux, OSX, etc.
  17. Dmitry Arefiev

    Backup FB3 Embedded through TIBBackup component

    Changing method to code below and setting FDPhysFBDriverLink1.Embedded to True will make it working. Without that the only workaround is to renamed fbclient.dll into fbembed.dll. procedure TIBLib.LoadFB(const AVendorHome, AVendorLib: String; AEmbedded, AThreadSafe: Boolean); {$IFNDEF FireDAC_IB_STATIC} const C_FBClient: String = {$IFDEF MSWINDOWS} 'fbclient' {$ENDIF} {$IFDEF POSIX} 'libfbclient' {$ENDIF} + C_FD_DLLExt; C_FBEmbed: String = {$IFDEF MSWINDOWS} 'fbembed' {$ENDIF} {$IFDEF POSIX} 'libfbembed' {$ENDIF} + C_FD_DLLExt; {$ENDIF} begin if AEmbedded then LoadBase(AVendorHome, AVendorLib, AThreadSafe {$IFNDEF FireDAC_IB_STATIC}, [C_FBEmbed, C_FBClient] {$ENDIF}) else LoadBase(AVendorHome, AVendorLib, AThreadSafe {$IFNDEF FireDAC_IB_STATIC}, [C_FBClient, C_FBEmbed] {$ENDIF}); if AEmbedded and (Version >= ivFB030000) then FEmbedded := True; end;
  18. Dmitry Arefiev

    Backup FB3 Embedded through TIBBackup component

    This is something to report to quality.embarcadero.com ...
  19. I am remembering / expecting that "{}" are not supported by SQL Server ODBC driver. Really by ODBC itself (the same with other ODBC drivers). Consider that as limitation of FireDAC SQL Server driver, which uses SQL Server ODBC driver internally.
  20. What is RAD Studio version ?
  21. Dmitry Arefiev

    General DB access question -- paging query results

    @Lars Fosdal, this feature is supported for 2008 too. In general, it will produce 3 different syntax's depending on SQL Server version. @Attila Kovacs, no, sorry.
  22. Dmitry Arefiev

    General DB access question -- paging query results

    SELECT <your query> OFFSET 19900 ROWS FETCH FIRST 100 ROWS ONLY That for SQL Server 2012 and higher. Different SQL will be generated for older versions.
  23. Dmitry Arefiev

    SQLBindParameter error with TFDQuery / ODBC

    This is known FireDAC issue: https://quality.embarcadero.com/browse/RSP-20857
  24. Dmitry Arefiev

    Rio has a broken REST Library

    Do we have a report for this ?