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.

10.4.1 07-Jul-25

Added support for Lazarus 4.0
Resolved an issue with declaring the TValueArr data type in C++ Builder
Fixed a bug where setting SQL in the Query component changed the case of a parameter name
Fixed a bug that occurred when calling the FindKey method on a cloned dataset
Fixed a bug that occurred when reserved words were used as field names in filters
Fixed a memory leak that occurred when an exception was raised while opening a TVirtualQuery
Fixed an issue with incorrect query results when using a parameter of type ftGuid in TVirtualQuery
Fixed an issue with adding new fields to TVirtualTable after calling the DeleteFields method

Oracle data provider

Introduced the DynamicReadThreshold option to optimize memory usage by dynamically reading VARCHAR2 and NVARCHAR2 values
Resolved an issue with reading LOBs in threads

SQLServer data provider

Fixed a bug with auto-generating queries for tables containing special characters in their names
Fixed a bug with updating aggregate fields when refreshing a Detail dataset in a master/detail relationship
Fixed a bug where an additional connection to the server was created after fetching multiple result sets

MySQL data provider

Fixed a bug that caused an assertion failure when handling stored procedures without SELECT privileges

PostgreSQL data provider

Fixed a bug with reading long error responses
Fixed a bug that caused an access violation when using OpenSSL
Fixed a bug that caused application freezing in multi-threaded mode
Resolved an issue with array handling in unnamed code blocks
Fixed a bug related to the ParamCheck property behavior
Resolved an OutOfMemory error that occurred when working with large datasets

InterBase data provider

Fixed a bug in the QueryRecCount option when executing queries with the NULLS FIRST clause and FetchAll set to False
Fixed a bug that caused incorrect display of error messages containing international characters

ASE data provider

Fixed an issue with fetching text fields when UseUnicode was set to True

DBF data provider

Resolved an issue with incorrect results returned by queries containing a "not equal" condition in the WHERE clause

Access data provider

Fixed a bug that caused an access violation when executing a statement containing a LIKE clause

Excel data provider

Improved detection of column data types in Direct mode

Additional Information