Devart UniDAC v12.1.0 Professional for D13

Download Devart UniDAC v12.1.0 Professional for D13

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.

12.1.0 29-Sep-26

Added support for RAD Studio 13 Florence Release 2
Improved support for the Arm64EC target platform
Added support for Lazarus 4.8
Added the voAssignReadOnly and voAssignRequired options to the VirtualTable component to control field attributes when calling Assign()
Improved handling of the UpdatingTable property when a query contains multiple references to the same table
Removed the deprecated AutoCommit property from the Script component
Removed the insecure MD5 hashing algorithm from the tunnel.php script
Fixed an issue with incorrect field ordering when using CloneCursor()

Oracle data provider

Added the AutoCommit specific option to the SQL, Table, Query, StoredProc, and Script components (Oracle provider)
Fixed an issue that caused TOraAlerter to hang when the connection was lost

SQLServer data provider

Added support for Microsoft SQL Server 2025
Added support for Always Encrypted

InterBase data provider

Added the AutoCommit specific option to the Script component
Improved generation of INSERT and UPDATE statements when DMLRefresh is enabled
Added support for the TrustedAuthentication specific option in TUniConnection
Added support for Wait mode and Lock timeout in the transaction component
Fixed an issue with the ExtendedFieldsInfo option when working with InterBase
Fixed an issue that caused the "arithmetic exception, numeric overflow, expected length x, actual y" error when opening tables with computed fields

MySQL data provider

Added support for MySQL 9.7.x
Added support for generated columns
Added support for handling the new ER_CLIENT_INTERACTION_TIMEOUT error packet
Added support for the authentication_ldap_sasl authentication plugin with the GSSAPI mechanism
Improved support for the GSSAPI authentication plugin
Fixed an issue with incorrect INSERT statement generation when a SELECT statement included fields from multiple tables
Fixed an issue that caused the "Record was changed by another user" error when calling the TMyTable.Lock() method
Fixed an issue that occurred when both FlatBuffers and UseUnicode were set to True

PostgreSQL data provider

Added the AutoCommit specific option to the SQL, Table, Query, StoredProc, Script, and Dump components
Added the ReadOnly connection option
Added the SNI SSL option to the Connection component
Added the ClientCharset option to the Connection component
Added support for the pv32 protocol in the Connection component
Added the Matview table metadata kind to the TUniMetaData component
Fixed an issue where the Script component always ran with AutoCommit set to True, regardless of the specified AutoCommit value
Fixed an issue with using functions when FetchAll is set to False and CursorWithHold is set to True
Fixed an issue with using parameters and AsFloat for BIGINT fields
Fixed an issue that caused prepared statements to accumulate on the server

SQLite data provider

Fixed an issue that caused incorrect results when opening a parameterized dataset with AutoPrepare and AdvancedTypeDetection enabled

NexusDB data provider

Added support of NexusDB 4.75.20
Added support for read-only transactions
Improved data loading performance with TUniLoader

MongoDB data provider

Fixed several issues with Decimal128 data type handling

DBF data provider

Improved compatibility with the Codebase format
Improved the AllFieldsAsNullable specific option when working with Visual FoxPro
Fixed an issue with updating LOGICAL fields
Fixed an issue that caused an assertion failure when updating a record

Access data provider

Improved compatibility with the Access 97 (Microsoft Jet 3) format

Excel data provider

Fixed an issue that caused the "vtable constructor failed" exception when opening a workbook

Salesforce data provider

Added support for server-to-server authentication