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.

12.0.1 15-Jun-26

• Fixed a bug that caused the "Invalid package handle" error when closing the IDE on Windows on Arm
• Resolved an issue that could cause an AccessViolation when changing the provider in the Connection component with DisconnectedMode enabled
• Fixed a bug that caused incorrect query results in the VirtualQuery component when a BDE dataset was used as the data source

Oracle data provider

• Fixed an issue with time zone conversion for TIMESTAMP WITH TIME ZONE values

SQLServer data provider

• Fixed an issue with handling names that contain consecutive dots in Direct mode

InterBase data provider

• Fixed an issue with updating datasets that use composite primary keys containing identity columns

MySQL data provider

• Fixed a bug that caused the ReceiveHeader: Net packets out of order error when wait_timeout expired
• Fixed a bug in TMyScript script execution when the default delimiter (;) was used and the script contained the DELIMITER ;; statement

PostgreSQL data provider

• Fixed a bug that caused the "Incompatible types" error
• Resolved an issue related to parameter handling
• Fixed an issue with saving parameters in UniSQL
• Replaced the UseSystemLocale Boolean connection option with the SystemLocale charset option
• Fixed an Access Violation that could occur when using connection pooling with master-detail UUID fields
• Resolved an issue that could cause an AccessViolation when using C++Builder Windows 64-bit (Modern) compilation

SQLite data provider

• Fixed an error that occurred when compiling the LiteStaticCall unit

NexusDB data provider

• Added support for the DatabaseReadOnly option on both Remote and Embedded servers

DB2 data provider

• Resolved an issue with missing table fields on the SQL Generator tab of the Query Editor window

Additional Information