Devart UniDAC v10.4.0 Professional for Delphi 6 - 12 Athens
Devart UniDAC v10.4.0 Professional for Delphi 6 - 12 Athens
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.0 20-Mar-25
Added support for RAD Studio 12 Athens Release 3
Added support for the RAD Studio 64-bit IDE
Added support for Lazarus 3.8
Added support for the JSON file format in the LoadFromFile method of the VirtualTable component
Added support for the TurboPack SynEdit package in component editors
Added support for syntax highlighting in component editors in Lazarus on the Windows platform
Added support for parameters in the Script component
Added the IndentFormat argument to the SaveToXML method of the dataset to decrease file size
Added the SaveToJSON method for serializing a dataset to the JSON format
Added the ability to use readonly fields in the SQL Generator at design-time
Improved work with design-time editors in the High DPI mode
Fixed a bug with ambiguity between the CRJSON.TJSONObject and System.Json.TJSONObject classes
Fixed a bug with opening VirtualQuery after modifying the source dataset
Fixed a bug with the TVirtualTable.Assign method when the VirtualTable has persistent fields
Oracle data provider
Added support for auto-login wallets
Added support for the BOOLEAN data type in Oracle 23 and higher
Added support for parameters in the Script component
Improved query performance for obtaining a primary key
Improved detection of the MERGE statement type in the Direct mode
Resolved an issue with the redundant selection of NLS parameters when opening a connection from the connection pool
SQLServer data provider
Added the Charset-specific connection option for the Direct mode
Fixed a bug with limitations for the PacketSize connection option in the Direct mode
MySQL data provider
Added support for MySQL 9
Added support for password-protected private key for SSL protocol
Added the EMySqlNetException class for internal errors in the MySQL protocol
Fixed a bug with unloading OpenSSL libraries when connection pooling is used
PostgreSQL data provider
Added support for PostgreSQL 17
Added support for the COPY ... TO STDOUT statement
Added support for password-protected private key for SSL protocol
Fixed a bug with parameter value conversion
Fixed a bug with the bytea data type on a non-Unicode server
Fixed a bug with using the real type when UnpreparedExecute = False
Fixed a bug with unloading OpenSSL libraries when connection pooling is used
Fixed a bug with AV failure at executiog Refresh when connection pooling is used
SQLite data provider
Fixed a bug with updating a record in the dataset that has key fields of the TEXT type
ASE data provider
Added support for connection via the SSL protocol
Added support for password-protected private key for SSL protocol
Access data provider
Fixed a bug with using indexes on text fields
Fixed a bug with accessing linked tables
Excel data provider
Fixed a bug with reading sheet names from a workbook
Added support for RAD Studio 12 Athens Release 3
Added support for the RAD Studio 64-bit IDE
Added support for Lazarus 3.8
Added support for the JSON file format in the LoadFromFile method of the VirtualTable component
Added support for the TurboPack SynEdit package in component editors
Added support for syntax highlighting in component editors in Lazarus on the Windows platform
Added support for parameters in the Script component
Added the IndentFormat argument to the SaveToXML method of the dataset to decrease file size
Added the SaveToJSON method for serializing a dataset to the JSON format
Added the ability to use readonly fields in the SQL Generator at design-time
Improved work with design-time editors in the High DPI mode
Fixed a bug with ambiguity between the CRJSON.TJSONObject and System.Json.TJSONObject classes
Fixed a bug with opening VirtualQuery after modifying the source dataset
Fixed a bug with the TVirtualTable.Assign method when the VirtualTable has persistent fields
Oracle data provider
Added support for auto-login wallets
Added support for the BOOLEAN data type in Oracle 23 and higher
Added support for parameters in the Script component
Improved query performance for obtaining a primary key
Improved detection of the MERGE statement type in the Direct mode
Resolved an issue with the redundant selection of NLS parameters when opening a connection from the connection pool
SQLServer data provider
Added the Charset-specific connection option for the Direct mode
Fixed a bug with limitations for the PacketSize connection option in the Direct mode
MySQL data provider
Added support for MySQL 9
Added support for password-protected private key for SSL protocol
Added the EMySqlNetException class for internal errors in the MySQL protocol
Fixed a bug with unloading OpenSSL libraries when connection pooling is used
PostgreSQL data provider
Added support for PostgreSQL 17
Added support for the COPY ... TO STDOUT statement
Added support for password-protected private key for SSL protocol
Fixed a bug with parameter value conversion
Fixed a bug with the bytea data type on a non-Unicode server
Fixed a bug with using the real type when UnpreparedExecute = False
Fixed a bug with unloading OpenSSL libraries when connection pooling is used
Fixed a bug with AV failure at executiog Refresh when connection pooling is used
SQLite data provider
Fixed a bug with updating a record in the dataset that has key fields of the TEXT type
ASE data provider
Added support for connection via the SSL protocol
Added support for password-protected private key for SSL protocol
Access data provider
Fixed a bug with using indexes on text fields
Fixed a bug with accessing linked tables
Excel data provider
Fixed a bug with reading sheet names from a workbook