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.3.0 27-Sep-24

Added support for RAD Studio 12 Athens Release 2
Added support for C++Builder 64-bit Windows (Modern) Application Development
Added support for Lazarus 3.4
Added provider for Microsoft Excel
Added C++Builder demo components for working with SecureBridge
Fixed bug in VirtualQuery with incorrect results of a query containing the IN operator
Fixed bug in VirtualTable with the "Invalid pointer operation" exception when closing the application
Fixed bug with the "Macro redefined" warning in CBuilder projects

Oracle data provider

Fixed bug with connecting to patched Oracle 19 and higher in the Direct mode

SQLServer data provider

Added support for Variant OUT parameters in Direct mode
Added datetime format when using timestamp macros
Fixed bug with preparing SQL statements that contain varbinary(max) parameters
Fixed bug with transaction handling when executing a stored procedure in the Direct mode
Fixed bug with fetching data in the NonBlocking mode
Fixed bug with "The SQL statement is not allowable for a bulk operation" when enabling the context of a change
Fixed bug with string param value truncation when using the prSQL provider
Fixed bug with processing datetime fields in SQL Server Compact Edition
Fixed bug with binding time parameters by OLEDB providers
Fixed bug with memory leak in Trial Edition

MySQL data provider

Added the WriteBOM specific option for TUniDump
Fixed bug with AV on closing the application when Pooling=True in MySQL Embedded
Fixed bug with executing Stored Procedure for manually created parameters
Fixed bug with incorrect behavior of TCRSSLIOHandler.IsSecure when FetchAl = False

PostgreSQL data provider

Improved performance
Added support for the pgvector extension
Added the UseGeneratedColumns specific option for TUniTable, TUniQuery, TUniStoredProc
Added the WriteBOM specific option for TUniDump
Fixed bug with getting default field values when using a not default public schema
Fixed bug with parsing composite data type
Fixed bug with a query when MATERIALIZED is used
Fixed bug with Access Violation when converting an empty timestamp value
Fixed bug with a user using tables named pg_class
Fixed bug with using tables with the same names in different schemas
Fixed bug with the query "SHOW ALL" when the FetchAll option is set to False
Fixed bug with parsing numeric data type when using arrays in a query

InterBase data provider

Fixed bug with using CutOffParams global variable when a string contains international symbols

SQLite data provider

Added the EnableAutoInc specific option for UniTable and UniQuery components
Added the WriteBOM specific option for TUniDump
Fixed bug with incorrect value when updating a float-type column in a 32-bit application on Windows ARM

MongoDB data provider

Fixed bug with an error when a document has a field with the same name as the collection name

NexusDB data provider

Added support of NexusDB 4.75.10
Improved performance of working with stored procedures

Access data provider

Added support for accessing Select and Union queries as views in the Direct mode

Additional Information