Description

Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Lazarus (Free Pascal). We have combined the experience of long-term successful development into one product, which provides unified access to the popular database servers like Oracle, Microsoft SQL Server, MySQL, InterBase, Firebird, PostgreSQL, SQLite, DB2, Microsoft Access, Sybase Advantage Database Server, Sybase Adaptive Server Enterprise, and other databases (using ODBC provider).

UniDAC offers unified approach to the database-related applications development process. That means you can switch easily between different databases in your projects without going deep into their specifics.

Using UniDAC with its server-independent interface is the best way to create cross-database applications. UniDAC gives outstanding flexibility and independence to your projects.

Server-Aware Providers
UniDAC chooses the best way specific to the server to perform most operations. Every UniDAC data provider uses server-specific native connectivity. All operations with data are performed by providers automatically considering the selected database server peculiarities.

Cross-Platform Solution for Delphi, C++Builder, and Lazarus
UniDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both x86 and x64 platforms. UniDAC also provides support for the FireMonkey platform, which allows you to develop visually spectacular high-performance desktop and mobile native applications.

Server-Independent SQL
When developing database applications that allow working with several databases, one of the key points is writing of server-independent SQL. In UniDAC, the server-independent SQL support is implemented by means of the powerful macros engine, that produces dynamic SQL by replacing parts of the query statements with user-defined code.

11.0.0 17-Sep-25

Added support for RAD Studio 13 Florence
Added support for Lazarus 4.2
Added support for system proxy settings to the TProxyOptions class for HTTP tunnelling
Added the Pooled function to the TCustomDAConnection component
Added support for ReportBuilder 23 in the Demo project
Resolved an issue where all connections were removed from the pool if TPoolingOptions.MinPoolSize was set to a value greater than 0
Resolved an issue where getting the record count failed if the query contained an ORDER BY clause
Resolved an issue with C++Builder compilation
Resolved an issue that caused a memory leak in the GetIPInterfaces procedure
Fixed paths in *.dproj files for IOHandlers and updated the documentation
Fixed a bug that triggered the "Record/Key deleted" error when deleting a record in the VirtualQuery component
Resolved an issue with clearing field values in the VirtualQuery component
Fixed a bug that occurred when loading the VirtualTable component with lookup fields

Oracle data provider

Added support for the BOOLEAN data type in Direct mode for Oracle 23 and later
Added support for passwords longer than 30 characters in Direct mode for Oracle 23 and later
Added support for Bearer Token authentication when connecting through HTTP tunnel
Added the SelfEvents specific option to TUniAlerter for enabling or disabling receiving your own events
Fixed an issue with OUT parameters returning NULL values when an OUT CURSOR parameter was present
Fixed an issue with dynamic fetching Unicode values in OCI mode

SQLServer data provider

Added support for Bearer Token authentication when connecting through HTTP tunnel
Added the MSOLEDBEncryptType connection option for the MSOLEDB provider
Added the UseNoBrowseTable connection option to prevent calling "SET NO_BROWSETABLE ON"
Added support for the MERGE batch operation (MSSQL Server provider)
Fixed a bug where the tunnel.php file was missing from the installer
Resolved an issue where looping through a dataset caused an "Invalid pointer operation" exception
Fixed the error message for distributed transactions in Direct mode

MySQL data provider

Added support for MariaDB 12
Added support for the UUID data type in MariaDB 10.7 and later
Added support for the INET4 and INET6 data types in MariaDB 10.10 and later
Added support for Bearer Token authentication when connecting through HTTP tunnel
Added the InsertBatchSize option to the TUniDump component to set the size of the SQLInsert query
Added the AnsiQuotesMode option to set the ANSI_QUOTES value for the sql_mode variable
Improved triggers backup with TUniDump
Fixed a bug with double-quoting of the database name when performing a backup with TMyDump
Resolved an issue with TMyDump that occurred when a database name contained reserved words
Resolved an issue where connecting to MySQL 4.0 or earlier caused the "sql_mode is not supported in MySQL versions 4.0 and earlier" error

PostgreSQL data provider

Added support for Bearer Token authentication when connecting through HTTP tunnel
Improved support for array data types
Improved connection opening performance
Fixed a bug that occurred when calling the FindKey method with an AnsiString parameter
Resolved an issue where numeric types were incorrectly treated as float types
Resolved an issue where UNION queries triggered an "Error Portal PORTALST does not exist" message
Fixed a bug that occurred when working with a partitioned table

Redshift data provider

Added support for Bearer Token authentication when connecting through HTTP tunnel

InterBase data provider

Added the SQLState property to EUniError.InnerError to store the SQLSTATE completion code
Improved the format of the DEFAULT_VALUE column in TIBCMetaData (when MetaKind = Column) to return values in a clear text representation
Fixed a bug that caused an "Utf8ToWs: Destination is nil" assertion failure when using MasterDetailed with UseUnicode = True
Fixed an issue with INSERT SQL query generation when DMLRefresh = True and UpdateAllFields = False
Fixed a bug that occurred when using SQL Dialect 1 with the DATE data type

SQLite data provider

Added support for the ISO8601-like time format for the TimeFormat property of the LiteConnection component
Fixed a bug that occurred when reinitializing the client library after a connection error

DBF data provider

Improved support of the HiPerSix database format
Resolved an issue with reading tables in the dBASE III database format
Fixed an issue that occurred when querying tables with LOGICAL fields containing both T/F and Y/N values

Access data provider

Significantly improved the performance of DML operations executed within a transaction
Added the CacheSize and CacheLifetime options to improve performance in ExclusiveLock mode
Added the PartialIndex option to improve SELECT performance
Resolved an issue where SELECT statements returned incorrect results if the WHERE clause used the < operator

NexusDB data provider

Added support of NexusDB 4.75.17
Significantly improved support for filtering when ServerCursor = True
Fixed an issue with incorrect behavior of the Locate method when using ServerCursor
Fixed a bug with record count retrieval when using filtering and ServerCursor = True

Additional Information