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.

7.0.1

RAD Studio 10.2 Tokyo is supported

Linux in RAD Studio 10.2 Tokyo is supported

Lazarus 1.6.4 and Free Pascal 3.0.2 is supported

Bug with AV failure in TUniProvider in multi-threading application is fixed

Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed

Bug with detecting parameters by name in ExecSQLEx is fixed

Bug with reading Memo as WideMemo is fixed

Bug with field name quoting in a filter expression is fixed

Bug with handling parameter values of BLOB type in batch operations is fixed

Bug with memory leak in TVirtualDataSet is fixed

Bug with processing LEFT JOIN on text fields in TVirtualQuery is fixed

Bug with updating records with text primary key in TVirtualQuery is fixed

Oracle data provider

Oracle Encryption in the Direct mode is supported

Oracle Data Integrity in the Direct mode is supported

Oracle Cloud (DBaaS) in the Direct mode is supported

Oracle 12c authentication in the Direct mode is supported

SECUREFILE in the Direct mode is supported

Prefetch LOBs for Oracle 11 and higher is supported

EDITIONABLE and NONEDITIONABLE clause is supported

The PrefetchLobSize option is added

Field size detecting for servers with multi-byte charset when UseUnicode=False is improved

Now NUMBER data type without fixed scale has precision=39 and scale=39 instead of 38

Bug with special symbols in password in the Direct mode is fixed

Bug with write BLOB to SECUREFILE for Oracle XE in the Direct mode is fixed

Bug with single quote inside double quotes in SQL is fixed

Bug with resizing DML parameters array is fixed

SQLServer data provider

Bug with setting IsolationLevel on connection establishing in the Direct mode is fixed

Bug with detection of field aliases for query with the JOIN statement is fixed

InterBase data provider

Possibility to manage batch operations using a transaction is added

Possibility to obtain active transaction number using DBMonitor is added

Bug with handling the "Database shutdown" error is fixed

Bug with handling parameters of the Currency type is fixed

Bug with AV when the number of values of a batch parameter is too large is fixed

Bug with using batch parameters of Bytes type is fixed

Bug with setting parameters of a custom transaction in Lazarus is fixed

Bug with reading BLOBs when the CacheBlobs property is set to False is fixed

PostgreSQL data provider

Bug with the RefreshRecord method is fixed

Bug with escaping BLOB data when protocol version 2 is used is fixed

Bug with executing a stored procedure via the Query component with FetchAll = False is fixed

Bug with executing a batch operation after changing SQL is fixed

Bug with international characters in error messages is fixed

SQLite data provider

Now the Direct mode is based on the SQLite engine version 3.17.0

Bug with VACUUM command in Direct Mode is fixed

Bug with query parameters binding is fixed

NexusDB data provider

Support for using ConnectionString is added

Support for using the TfmtBCD fields is added

Support for the SmartFetch mode is improved

Bug with using DATE, TIME, and TIMESTAMP literals is fixed

MongoDB data provider

New MongoDB provider is added

DBF data provider

Direct mode is supported

Additional Information