Devart UniDAC Professional v10.0 for Delphi 12, 11, 10.4, 2007 and 7
Devart UniDAC Professional v10.1.0 for Delphi 12, 11, 10.4, 2007 and 7
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.1.0 19-Feb-24
Lazarus 3.0 is supported
Fixed bug with empty field values when insert via the VirtualQuery component
Oracle data provider
Added support for connect to servers with enabled Security Banners in the Direct mode
Improved error message about a non-existent database object in another schema
Fixed bug with CLOB reading when UseUnicode=True in OCI mode
Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
Fixed bug in TUniScript with parsing the CREATE JAVA SOURCE statmets
Fixed bug with refresh data after DML statements executing
SQLServer data provider
Fixed bug with preparing Stored Procedure execution
Fixed bug with setting parameter values on record posting
Fixed bug with SQL Generator in the design-time when the database name must be quoted
MySQL data provider
Fixed bug with getting warning message of using bmBinary mode
Fixed bug with assertion failure or AV in batch operation
PostgreSQL data provider
Improved work with column default values
Improved work with RefreshRecord queries
Improved work with arrays in queries
Fixed bug with "Current transaction is aborted, commands ignored until end of transaction block."
Fixed bug with "Multiple transactions are not supported by the database."
Fixed bug with "date/time field value out of range" for IDE12 Win64 target platform
InterBase data provider
Added support for Firebird 5 (InterBase provider)
Added support for multiple rows being returned by DML with the RETURNING clause
Improved compatibility with macOS Sonoma
Fixed bug with setting ReadOnly properties of fields with the same names in a join SQL query
Fixed bug with using CutOffParams global variable when UseUnicode set to True
Fixed bug with using the parameter value size greater than the previous parameter size
Fixed bug with work Date/Time data types parameters
SQLite data provider
The RealAsDouble option for the Connection component is added
Fixed bug with detecting foreign key columns in the MetaData component
DBF data provider
Added support for the UTF8 encoding
Added support for tables with duplicate column names
Improved compatibility with Quantum GIS
Improved error handling when using the IgnoreDataErrors option
Fixed bug with adding a column when the field name must be quoted
NexusDB data provider
Added support of NexusDB 4.75.01
Fixed bug with AV on closing an application when connection pooling is used
MS Access data provider
Added support for Direct mode
DB2 data provider
Added support SSL connection
ODBC data provider
Fixed bug with the "Cannot modify a read-only dataset" exception in SQL Anywhere
Lazarus 3.0 is supported
Fixed bug with empty field values when insert via the VirtualQuery component
Oracle data provider
Added support for connect to servers with enabled Security Banners in the Direct mode
Improved error message about a non-existent database object in another schema
Fixed bug with CLOB reading when UseUnicode=True in OCI mode
Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
Fixed bug in TUniScript with parsing the CREATE JAVA SOURCE statmets
Fixed bug with refresh data after DML statements executing
SQLServer data provider
Fixed bug with preparing Stored Procedure execution
Fixed bug with setting parameter values on record posting
Fixed bug with SQL Generator in the design-time when the database name must be quoted
MySQL data provider
Fixed bug with getting warning message of using bmBinary mode
Fixed bug with assertion failure or AV in batch operation
PostgreSQL data provider
Improved work with column default values
Improved work with RefreshRecord queries
Improved work with arrays in queries
Fixed bug with "Current transaction is aborted, commands ignored until end of transaction block."
Fixed bug with "Multiple transactions are not supported by the database."
Fixed bug with "date/time field value out of range" for IDE12 Win64 target platform
InterBase data provider
Added support for Firebird 5 (InterBase provider)
Added support for multiple rows being returned by DML with the RETURNING clause
Improved compatibility with macOS Sonoma
Fixed bug with setting ReadOnly properties of fields with the same names in a join SQL query
Fixed bug with using CutOffParams global variable when UseUnicode set to True
Fixed bug with using the parameter value size greater than the previous parameter size
Fixed bug with work Date/Time data types parameters
SQLite data provider
The RealAsDouble option for the Connection component is added
Fixed bug with detecting foreign key columns in the MetaData component
DBF data provider
Added support for the UTF8 encoding
Added support for tables with duplicate column names
Improved compatibility with Quantum GIS
Improved error handling when using the IgnoreDataErrors option
Fixed bug with adding a column when the field name must be quoted
NexusDB data provider
Added support of NexusDB 4.75.01
Fixed bug with AV on closing an application when connection pooling is used
MS Access data provider
Added support for Direct mode
DB2 data provider
Added support SSL connection
ODBC data provider
Fixed bug with the "Cannot modify a read-only dataset" exception in SQL Anywhere
Only for V.I.P
Warning! You are not allowed to view this text.