Devart UniDAC 8.1.2 Professional
Devart UniDAC 8.1.2 Professional
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.
8.1.2 26-Nov-19
Android 64-bit is supported
Lazarus 2.0.6 is supported
Now Trial edition for macOS and Linux is fully functional
Bug with mapping a MEMO field to a floating-point field type in the TVirtualQuery is fixed
Bug with the Loader component when UniDirectional set to True for source dataset is fixed
Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
Bug with mapping to BCD fields when TClientDataSet is used is fixed
Bug with resetting the range values when executing the Refresh method is fixed
Bug with AV failure when using encryption is fixed
Bug with using the FieldOrigins property is fixed
Several bugs that occurred when using DataSet Manager are fixed
Oracle data provider
Oracle 19c is supported
Long database object names is supported
Bug with UTF-8 encoding for Oracle 9 in the Direct mode is fixed
Bug with memory leak on session connect in the Direct mode is fixed
Bug with init session timezone in the Direct mode is fixed
Bug with rounding float values in the Direct mode is fixed
SQLServer data provider
TLS 1.2 support in the Direct mode is added
The connection option MultiSubnetFailover for the MSOLEDB provider is added
Updating data after invoking the Refresh method is fixed
Bug with connecting to SQL Server 2000 in the Direct mode is fixed
Use of the Server property that contains Port in the Direct mode is added
Bug with the NativeClientVersion connection option being set from ConnectionString is fixed
MySQL data provider
OpenSSL 1.1 library is supported
Bug with freezing of the TUniConnection design-time editor for MySQL versions older than 4.1 is fixed
Bug with international characters in error messages when UseUnocode = True is fixed
PostgreSQL data provider
PostgreSQL 12 is supported
OpenSSL 1.1 library is supported
InterBase data provider
Interbase 2020 is supported
Improved performance when using pooling
Bug with using the array data type in a table with quoted name is fixed
Bug with executing the CREATE DATABASE statement when Pooling is enabled is fixed
Bug with the UniLoader component when BooleanDomainFields set to True is fixed
Bug with the "segment buffer length shorter than expected" error is fixed
SQLite data provider
Bug with AV when executing the INSERT operation is fixed
Bug with a wrong default value of a DATETIME field when inserting a record is fixed
Bug with mapping a MEMO field to a floating-point field type is fixed
NexusDB data provider
Bug with executing batch operations is fixed
MongoDB data provider
The LowerCaseObjectId specific option for the Connection component is added
Bug with reading documents containing array values is fixed
DBF data provider
The IdentifierCase specific option is added
The cmUnsafe value for the ConnectMode specific option is added
Bug with refreshing a dataset after adding records via another connection is fixed
Bug with inserting records with empty field values is fixed
Bug with adding a field of type MEMO to a table is fixed
Bug with updating date fields is fixed
Bug with using native indexes when executing SQL queries is fixed
Bug with mapping a MEMO field to a floating-point field type is fixed
Bug with upditing records in a table, which has a compound index, is fixed
Bug with detecting dBaseIV file format is fixed
Bug with using character fields in a WHERE clause is fixed
Bug with opening tables, which table path contains a dot, is fixed
Bug with using date fields in a WHERE clause on Linux is fixed
Android 64-bit is supported
Lazarus 2.0.6 is supported
Now Trial edition for macOS and Linux is fully functional
Bug with mapping a MEMO field to a floating-point field type in the TVirtualQuery is fixed
Bug with the Loader component when UniDirectional set to True for source dataset is fixed
Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
Bug with mapping to BCD fields when TClientDataSet is used is fixed
Bug with resetting the range values when executing the Refresh method is fixed
Bug with AV failure when using encryption is fixed
Bug with using the FieldOrigins property is fixed
Several bugs that occurred when using DataSet Manager are fixed
Oracle data provider
Oracle 19c is supported
Long database object names is supported
Bug with UTF-8 encoding for Oracle 9 in the Direct mode is fixed
Bug with memory leak on session connect in the Direct mode is fixed
Bug with init session timezone in the Direct mode is fixed
Bug with rounding float values in the Direct mode is fixed
SQLServer data provider
TLS 1.2 support in the Direct mode is added
The connection option MultiSubnetFailover for the MSOLEDB provider is added
Updating data after invoking the Refresh method is fixed
Bug with connecting to SQL Server 2000 in the Direct mode is fixed
Use of the Server property that contains Port in the Direct mode is added
Bug with the NativeClientVersion connection option being set from ConnectionString is fixed
MySQL data provider
OpenSSL 1.1 library is supported
Bug with freezing of the TUniConnection design-time editor for MySQL versions older than 4.1 is fixed
Bug with international characters in error messages when UseUnocode = True is fixed
PostgreSQL data provider
PostgreSQL 12 is supported
OpenSSL 1.1 library is supported
InterBase data provider
Interbase 2020 is supported
Improved performance when using pooling
Bug with using the array data type in a table with quoted name is fixed
Bug with executing the CREATE DATABASE statement when Pooling is enabled is fixed
Bug with the UniLoader component when BooleanDomainFields set to True is fixed
Bug with the "segment buffer length shorter than expected" error is fixed
SQLite data provider
Bug with AV when executing the INSERT operation is fixed
Bug with a wrong default value of a DATETIME field when inserting a record is fixed
Bug with mapping a MEMO field to a floating-point field type is fixed
NexusDB data provider
Bug with executing batch operations is fixed
MongoDB data provider
The LowerCaseObjectId specific option for the Connection component is added
Bug with reading documents containing array values is fixed
DBF data provider
The IdentifierCase specific option is added
The cmUnsafe value for the ConnectMode specific option is added
Bug with refreshing a dataset after adding records via another connection is fixed
Bug with inserting records with empty field values is fixed
Bug with adding a field of type MEMO to a table is fixed
Bug with updating date fields is fixed
Bug with using native indexes when executing SQL queries is fixed
Bug with mapping a MEMO field to a floating-point field type is fixed
Bug with upditing records in a table, which has a compound index, is fixed
Bug with detecting dBaseIV file format is fixed
Bug with using character fields in a WHERE clause is fixed
Bug with opening tables, which table path contains a dot, is fixed
Bug with using date fields in a WHERE clause on Linux is fixed
Only for V.I.P Warning! You are not allowed to view this text.