Devart UniDAC v10.2 Professional for Delphi 7 - 12 Athens
Devart UniDAC v10.2 Professional for Delphi 7 - 12 Athens
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.2.0 24-Apr-24
Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Added voResetAutoInc in the VirtualTable component that allows to reset AutoInc values on Clear
Fixed bug in VirtualQuery with querying source datasets that contain NULL column values
Oracle data provider
Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
Fixed bug with string value truncation when ConvertEOL=True for Oracle 11 or lower
Fixed bug with Connection Pooling in the Direct mode
SQLServer data provider
Microsoft Entra Service Principal authentication (auADServicePrincipal) in the prMSOLEDB provider is supported
Fixed bug with Microsoft Entra identity authentication (auADInteractive) in the prMSOLEDB provider
Fixed bug with updating datetime fields by OLEDB providers
Fixed bug with a zero-valued LastInsertID result
MySQL data provider
Fixed bug with incorrect executing of internal Rollback
PostgreSQL data provider
Improved work with generated fields
Fixed bug with processing identity field
Redshift data provider
Fixed bug with reading real fields
InterBase data provider
Fixed bug with incorrect results when using the RETURNING clause
Fixed bug with an error message about bad timezone ID
NexusDB data provider
Improved the Locate and FindKey methods' execution when using ServerCursor
Fixed bug with Access Violation when using Server Cursor and IndexFieldNames
SQLite data provider
Now the Direct mode is based on version 3.45.2 of the SQLite engine
Added support for automatic detection of transaction state when the transaction is controlled by an SQL statement
Fixed bug with using the SQLCiper library
DBF data provider
Fixed a bug with adding a blank record to the resultset
Fixed bug with opening tables whose field names contain characters after the line terminator
Access data provider
Fixed bug with sequential connection to a database
Fixed bug with the "Range check error" exception when querying a table
Fixed bug with incorrect RecordCount property value when FetchAll is set to True
BigCommerce data provider
Added metadata cache
Dynamics data provider
Added metadata cache
HubSpot data provider
Added metadata cache
Magento data provider
Added metadata cache
NetSuite data provider
Added metadata cache
NetSuite data provider
Added metadata cache
Salesforce data provider
Added metadata cache
Salesforce Salesforce Marcketing Cloud data provider
Added metadata cache
SugarCRM data provider
Added metadata cache
ZohoCRM data provider
Added metadata cache
Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Added voResetAutoInc in the VirtualTable component that allows to reset AutoInc values on Clear
Fixed bug in VirtualQuery with querying source datasets that contain NULL column values
Oracle data provider
Fixed bug with TIMESTAMP WITH TIME ZONE reading for Oracle 21 or higher in the Direct mode
Fixed bug with string value truncation when ConvertEOL=True for Oracle 11 or lower
Fixed bug with Connection Pooling in the Direct mode
SQLServer data provider
Microsoft Entra Service Principal authentication (auADServicePrincipal) in the prMSOLEDB provider is supported
Fixed bug with Microsoft Entra identity authentication (auADInteractive) in the prMSOLEDB provider
Fixed bug with updating datetime fields by OLEDB providers
Fixed bug with a zero-valued LastInsertID result
MySQL data provider
Fixed bug with incorrect executing of internal Rollback
PostgreSQL data provider
Improved work with generated fields
Fixed bug with processing identity field
Redshift data provider
Fixed bug with reading real fields
InterBase data provider
Fixed bug with incorrect results when using the RETURNING clause
Fixed bug with an error message about bad timezone ID
NexusDB data provider
Improved the Locate and FindKey methods' execution when using ServerCursor
Fixed bug with Access Violation when using Server Cursor and IndexFieldNames
SQLite data provider
Now the Direct mode is based on version 3.45.2 of the SQLite engine
Added support for automatic detection of transaction state when the transaction is controlled by an SQL statement
Fixed bug with using the SQLCiper library
DBF data provider
Fixed a bug with adding a blank record to the resultset
Fixed bug with opening tables whose field names contain characters after the line terminator
Access data provider
Fixed bug with sequential connection to a database
Fixed bug with the "Range check error" exception when querying a table
Fixed bug with incorrect RecordCount property value when FetchAll is set to True
BigCommerce data provider
Added metadata cache
Dynamics data provider
Added metadata cache
HubSpot data provider
Added metadata cache
Magento data provider
Added metadata cache
NetSuite data provider
Added metadata cache
NetSuite data provider
Added metadata cache
Salesforce data provider
Added metadata cache
Salesforce Salesforce Marcketing Cloud data provider
Added metadata cache
SugarCRM data provider
Added metadata cache
ZohoCRM data provider
Added metadata cache
Only for V.I.P
Warning! You are not allowed to view this text.