Universal Data Access Components (UniDAC) Releases

Released: Mar 10, 2020

Updates in 8.1.3

Features

Microsoft SQL Server data provider

  • Added UuidWithBraces option.
  • Improved performance of TMSLoader when loading data in Direct mode.

ASE data provider

  • Improved performance of TMSLoader when loading data in Direct mode.

Fixes

  • Fixed bug installing different editions of two or more DACs in a single system.
  • Fixed bug with SQL statements that contain fields with the same name from different tables.
  • Fixed bug executing SQL statements that contain comments using the Script component.
  • Fixed bug...

Released: Nov 26, 2019

Updates in 8.1.2

Features

  • Support for Android 64-bit.
  • Support for Lazarus 2.0.6.

Oracle data provider

  • Support for Oracle 19c.
  • Support for Long database object names.

SQLServer data provider

  • Added TLS 1.2 support in the Direct mode.
  • Added the MultiSubnetFailover connection option for MSOLEDB provider.
  • Use Server property that contains "Port" in Direct mode.

MySQL data provider

  • Support for OpenSSL 1.1 library.

PostgreSQL data provider

  • Support for PostgreSQL 12.
  • Support for OpenSSL 1.1 library.

InterBase data...

Released: Jul 22, 2019

Updates in 8.0.1

Features

  • Added support for macOS 64-bit.

Released: Jun 24, 2019

Updates in 7.5.13

Features

  • Added support for Lazarus 2.0.2.
  • Added TVirtualTable DefaultSortType property.
  • Improved performance of TVirtualTable SaveToFile/LoadFromFile methods
  • Oracle data provider
    • Added support for using the ChangePassword method.
  • SQLServer data provider
    • Added support for working with multiple threads sharing a single connection.
    • Added support for using ChangePassword method.
  • MySQL data provider
    • Improved performance of TMyDump for data dumping from a query.
    • Improved performance of describing...

Released: Nov 26, 2018

Updates in 7.4.11

Features

  • Added support for RAD Studio 10.3 Rio.
  • Added support for UPPER and LOWER functions for Unified SQL.

Oracle data provider

  • Oracle 18c support.
  • Implicit result sets in Oracle 12.

SQLServer data provider

  • QuoteNames option in TUniLoader to escape field names.

MySQL data provider

  • Support for PAM and Windows authentications

InterBase data provider

  • Write large blobs in pieces

PostgreSQL data provider

  • PostgreSQL 11 is support

SQLite data provider

  • Support for the BreakExec method in the Query...

Released: Jul 9, 2018

Updates in 7.3.8

Features

  • Added support for Lazarus 1.8.4.
  • Improved performance of batch operations.
  • Added demo projects for IntraWeb 14.
  • Added LocalUpdate property to TVirtualQuery.
  • Added AutoOpenSources option to TVirtualQuery.
  • Oracle data provider
    • Now non-compiled stored procedures can be described in Direct mode.
    • Improved performance of data fetching in Direct mode.
    • Improved performance of describing stored procedures in Direct mode.
    • Added support for TIMESTAMP WITH TIMEZONE in Direct mode.
  • SQL Server data...

Released: Apr 10, 2018

Updates in 7.2.7

Features

  • Added support for Lazarus 1.8.2.
  • Now the Detail dataset is not refreshed when editing a Master dataset.

Fixes

  • Fixed "Attempt to reopen open cursor" error when trying to execute Refresh method.
  • Fixed bug with missing libs for static linking in Lazarus.
  • Fixed bug executing batch operations with iteration = 1 and offset = 0.
  • Fixed bug re-opening a filtered dataset.
  • Fixed bug with data decryption in SmartFetch mode.
  • Fixed bug with data truncation while decrypting.
  • Fixed bug using field...

Released: Jan 18, 2018

Updates in 7.2.5

Features

  • Support for Lazarus 1.8 and FPC 3.0.4.
  • Support for custom constraints.
  • Added UseBlankValues property to the Loader component.
  • Added new Amazon Redshift provider.
  • SQLServer data provider
    • Support for Windows authentication in Direct mode.
  • MySQL data provider
    • Support for backup/restore of triggers and stored procedures.
  • InterBase data provider
    • Improved loading of default client library for 64-bit applications.
  • SQLite data provider
    • Support for Direct Mode in Lazarus.
    • Support for BIT type...

Released: Sep 29, 2017

Updates in 7.1.4

Features

  • Significantly improved performance of TVirtualQuery.
  • Added support for application-defined functions and collations in TVirtualQuery.
  • Support AutoInc fields in TVirtualTable.
  • New Cloud data providers: BigCommerce, Dynamics, FreshBooks, Magento, MailChimp, NetSuite, QuickBooks, Salesforce, Salesforce Marketing Cloud, SugarCRM and Zoho CRM.

Oracle data provider

  • Added support for Oracle 12c connection modes (SYSBACKUP, SYSDG, SYSKM) in Direct mode.
  • Added support for OS authentication in...

Released: Apr 5, 2017

Updates in 7.0.1

Features

  • Support for RAD Studio 10.2 Tokyo.
  • Support for Linux in RAD Studio 10.2 Tokyo.
  • Support for Lazarus 1.6.4 and Free Pascal 3.0.2.