Devart UniDAC Professional v10.1.0 for Delphi 12, 11, 10.4, 2007 and 7

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...


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.1.0 19-Feb-24

Lazarus 3.0 is supported
Fixed bug with empty field values when insert via the VirtualQuery component

Oracle data provider

Added support for connect to servers with enabled Security Banners in the Direct mode
Improved error message about a non-existent database object in another schema
Fixed bug with CLOB reading when UseUnicode=True in OCI mode
Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
Fixed bug in TUniScript with parsing the CREATE JAVA SOURCE statmets
Fixed bug with refresh data after DML statements executing

SQLServer data provider

Fixed bug with preparing Stored Procedure execution
Fixed bug with setting parameter values on record posting
Fixed bug with SQL Generator in the design-time when the database name must be quoted

MySQL data provider

Fixed bug with getting warning message of using bmBinary mode
Fixed bug with assertion failure or AV in batch operation

PostgreSQL data provider

Improved work with column default values
Improved work with RefreshRecord queries
Improved work with arrays in queries
Fixed bug with "Current transaction is aborted, commands ignored until end of transaction block."
Fixed bug with "Multiple transactions are not supported by the database."
Fixed bug with "date/time field value out of range" for IDE12 Win64 target platform

InterBase data provider

Added support for Firebird 5 (InterBase provider)
Added support for multiple rows being returned by DML with the RETURNING clause
Improved compatibility with macOS Sonoma
Fixed bug with setting ReadOnly properties of fields with the same names in a join SQL query
Fixed bug with using CutOffParams global variable when UseUnicode set to True
Fixed bug with using the parameter value size greater than the previous parameter size
Fixed bug with work Date/Time data types parameters

SQLite data provider

The RealAsDouble option for the Connection component is added
Fixed bug with detecting foreign key columns in the MetaData component

DBF data provider

Added support for the UTF8 encoding
Added support for tables with duplicate column names
Improved compatibility with Quantum GIS
Improved error handling when using the IgnoreDataErrors option
Fixed bug with adding a column when the field name must be quoted

NexusDB data provider

Added support of NexusDB 4.75.01
Fixed bug with AV on closing an application when connection pooling is used

MS Access data provider

Added support for Direct mode

DB2 data provider

Added support SSL connection

ODBC data provider

Fixed bug with the "Cannot modify a read-only dataset" exception in SQL Anywhere

Additional Information