Component Devart Universal Data Access Components (UniDAC)

[FireWind]

Devart Universal Data Access Components (UniDAC)

Universal Data Access Components (UniDAC) is a library of components that provides direct access to multiple databases from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms.

UniDAC provides transparent server-independent interfaces for working with different databases, and lets you change the client engine for a specific server type just by changing single connection option. It means that you can easily switch between different database servers in your cross-database UniDAC-based application.

Спойлер: Info & links

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, macOS, Linux, iOS, and Android, 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, producing dynamic SQL by replacing parts of the query statements with user-defined code.

Access Cloud Services​

UniDAC allows developing applications that work with data stored in such Cloud services as: BigCommerce, Dynamics CRM, FreshBooks, Magento, MailChimp, NetSuite, Salesforce, Salesforce MC, SugarCRM, QuickBooks, Zoho CRM. For this, it is enough to use UniDAC ODBC provider with any Для просмотра ссылки Войди или Зарегистрируйся.

Secure connection​

You can use SecureBridge components with data access components to embed an SSL, SSH, or HTTP/HTTPS clients into your application to establish a secure connection to the server.

Для просмотра ссылки Войди или Зарегистрируйся

 

[FireWind]

Universal Data Access Components (UniDAC) v8.3.1 with Source Code

Спойлер: History

8.3.1 26-Aug-20
* Lazarus 2.0.10 and FPC 3.2.0 are supported
* Performance of Batch Insert, Update, and Delete operations is improved
Oracle data provider
* Oracle 20c is supported
* Connection via SSL protocol is supported
* Connection via SSH protocol is supported
* Connection via HTTP tunnel is supported
SQLServer data provider
* SQL Server 2019 is supported
* Failure to connect in the Direct mode with different credentials after unsuсcessful initial connection attempt is fixed
SQLite data provider
* Bug with Data Type Mapping to the ftLargeint field type is fixed
DBF data provider
* Native dBase functions in a SQL statement are supported
MongoDB data provider
* Bug with using special characters in a username or password is fixed
* Bug with the "Out of memory" error when retrieving data from huge collections is fixed
ODBC data provider
* Error message retrieving from SQL Anywhere ODBC driver is improved

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.3.2 for Delphi 10.4.1 Sydney

Спойлер: History

8.3.2 14-Sep-20
* Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
* Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed
SQLServer data provider
* Bug with the "Wrong amount of parameters 4 in TableName" error when retrieving data from a linked server is fixed
* Bug with an assertion failure when manually creating parameters is fixed
MySQL data provider
* Bug with values getting cut off after calling the SHOW CREATE FUNCTION statement for MySQL 5.0.x is fixed (MySQL provider)

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.3.2 Pro for Delphi 10.4.1 Sydney (Retail)

Спойлер: History

8.3.2 14-Sep-20
* Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
* Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed
SQLServer data provider
* Bug with the "Wrong amount of parameters 4 in TableName" error when retrieving data from a linked server is fixed
* Bug with an assertion failure when manually creating parameters is fixed
MySQL data provider
* Bug with values getting cut off after calling the SHOW CREATE FUNCTION statement for MySQL 5.0.x is fixed (MySQL provider)

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.3.2 Pro for Delphi 10.3 Rio (Retail)

Спойлер: History

8.3.2 14-Sep-20
SQLServer data provider
* Bug with the "Wrong amount of parameters 4 in TableName" error when retrieving data from a linked server is fixed
* Bug with an assertion failure when manually creating parameters is fixed
MySQL data provider
* Bug with values getting cut off after calling the SHOW CREATE FUNCTION statement for MySQL 5.0.x is fixed (MySQL provider)

Спойлер: Link

password: dumpz.ws

 

[GuDron]

Для просмотра ссылки Войди или Зарегистрируйся
dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.4.1 Pro for Delphi & C++Builder 10.4 Sydney (Retail)

Спойлер: History

8.4.1 02-Mar-21

• RAD Studio 10.4.2 Sydney is supported
• macOS 11 Big Sur is supported
• iOS 14 is supported
• Android 11 is supported
• Performance of batch operations is improved
• Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
• The UseUnicode option in the VirtualQuery component is added

Oracle data provider

• Oracle 21c is supported
• The PrefetchRows option in the Direct mode is supported
• Data fetch performance in the Direct mode is improved
• LOB read/write performance is improved

SQLServer data provider

• LOB read/write performance in the Direct mode is improved

PostgreSQL data provider

• PostgreSQL 13 is supported
• Work in a multi-threaded environment through a single connection is supported
• The MultipleConnections option in the Connection component is added

InterBase data provider

• Over-the-Wire (OTW) encryption is supported
• Automatic detection of computed fields when generating update statements is improved
• Memory consumption in batch operations is reduced

SQLite data provider

• The LockingMode specific option in the Connection component is added
• The Synchronous specific option in the Connection component is added
• The JournalMode specific option in the Connection component is added
• Performance with default values of the new options is significantly improved

ASE data provider

• The TextSize specific option is added

DBF data provider

• The IgnoreIndexErrors specific option in the Connection component is added
• Performance of reading and writing MEMO and BLOB values is improved
• Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved

ODBC data provider

• Data fetch performance is improved
• LOB read/write performance is improved

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.4.1 Source for Delphi & C++Builder v6-10.4 and Lazarus

Спойлер: History

8.4.1 02-Mar-21

• RAD Studio 10.4.2 Sydney is supported
• macOS 11 Big Sur is supported
• iOS 14 is supported
• Android 11 is supported
• Performance of batch operations is improved
• Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
• The UseUnicode option in the VirtualQuery component is added

Oracle data provider

• Oracle 21c is supported
• The PrefetchRows option in the Direct mode is supported
• Data fetch performance in the Direct mode is improved
• LOB read/write performance is improved

SQLServer data provider

• LOB read/write performance in the Direct mode is improved

PostgreSQL data provider

• PostgreSQL 13 is supported
• Work in a multi-threaded environment through a single connection is supported
• The MultipleConnections option in the Connection component is added

InterBase data provider

• Over-the-Wire (OTW) encryption is supported
• Automatic detection of computed fields when generating update statements is improved
• Memory consumption in batch operations is reduced

SQLite data provider

• The LockingMode specific option in the Connection component is added
• The Synchronous specific option in the Connection component is added
• The JournalMode specific option in the Connection component is added
• Performance with default values of the new options is significantly improved

ASE data provider

• The TextSize specific option is added

DBF data provider

• The IgnoreIndexErrors specific option in the Connection component is added
• Performance of reading and writing MEMO and BLOB values is improved
• Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved

ODBC data provider

• Data fetch performance is improved
• LOB read/write performance is improved

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.4.1 Pro for Delphi & C++Builder 10.2-10.3 (Retail)

Спойлер: History

8.4.1 02-Mar-21

• RAD Studio 10.4.2 Sydney is supported
• macOS 11 Big Sur is supported
• iOS 14 is supported
• Android 11 is supported
• Performance of batch operations is improved
• Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
• The UseUnicode option in the VirtualQuery component is added

Oracle data provider

• Oracle 21c is supported
• The PrefetchRows option in the Direct mode is supported
• Data fetch performance in the Direct mode is improved
• LOB read/write performance is improved

SQLServer data provider

• LOB read/write performance in the Direct mode is improved

PostgreSQL data provider

• PostgreSQL 13 is supported
• Work in a multi-threaded environment through a single connection is supported
• The MultipleConnections option in the Connection component is added

InterBase data provider

• Over-the-Wire (OTW) encryption is supported
• Automatic detection of computed fields when generating update statements is improved
• Memory consumption in batch operations is reduced

SQLite data provider

• The LockingMode specific option in the Connection component is added
• The Synchronous specific option in the Connection component is added
• The JournalMode specific option in the Connection component is added
• Performance with default values of the new options is significantly improved

ASE data provider

• The TextSize specific option is added

DBF data provider

• The IgnoreIndexErrors specific option in the Connection component is added
• Performance of reading and writing MEMO and BLOB values is improved
• Work with dBaseV and dBaseVII tables when the DBFFormat option set to dfAuto is improved

ODBC data provider

• Data fetch performance is improved
• LOB read/write performance is improved

Спойлер: Links

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.4.3 Pro for Delphi & C++Builder 10.4 Sydney (Retail)

Спойлер: History

8.4.3 06-Apr-21
* Demo compatibility with new a version of SecureBridge is fixed
* Bug with assigning a BLOB parameter when the source data is loaded via the TParam.LoadFromStream method is fixed
Oracle data provider
* Bug with an Invalid pointer operation on Fetch is fixed
SQLServer data provider
* Bug a string parameter getting trimmed is fixed
PostgreSQL data provider
* Bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True is fixed
* Bug with reading server messages is fixed
InterBase data provider
* Bug with loading BLOB columns as strings using the Loader component is fixed
SQLite data provider
* JournalMode = jmDefault specific option value for the Connection component is added
* Bug with mapping the liteNull database type to the ftBLOB field type is fixed

8.4.2 26-Mar-21
* Lazarus 2.0.12 is supported
* Bug with the ConvertEOL connection option is fixed
* Bug with AV in applications using DBMonitor is fixed
* Bug with committing a transaction when LockMode = lmPessimistic is fixed
* Bug with getting values of calculated fields is fixed
Oracle data provider
* Bug with parameters that have Unknown data type on Prepare is fixed
* Bug with calling stored procedures when AutoCommit=False is fixed
* Bug with parameters for Oracle 19c in the Direct mode is fixed
* Bug with NUMBER fields when EnableFMTBCD=True is fixed
SQLServer data provider
* Bug with the data type mapping of varbinary fields is fixed
MySQL data provider
* Bug with the "Prepared statement contains too many placeholders" error in batch operations is fixed
PostgreSQL data provider
* Several bugs with the MultipleConnection option are fixed
* Several bugs with ProtocolVersion = pvAuto are fixed
* Bug with LockMode = lmPessimistic is fixed
InterBase data provider
* The default value of the BooleanDomainFields specific option reverted to True
NexusDB data provider
* NexusDB 4.50.26 is supported

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v8.4.2 Source for Delphi & C++Builder v6-10.4 and Lazarus

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v9.0.1 Pro for Delphi & C++Builder 10.4 Sydney (Retail)

Спойлер: History

9.0.1 13-Sep-21
* RAD Studio 11 Alexandria is supported
* macOS ARM is supported
* Added demo project for FastReport FMX
* Fixed bug with duplicate records when navigating through TVirtualDataSet for which a filter is set
* Fixed bug with persistent fields when saving and then reading data from file to TVirtualTable
* Fixed bug with setting a DateTime value before the year 1800 to TTimeField
* Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
* Fixed bug with memory leak on Locate by field with data type mapping
* Fixed bug with escaping wildcards in the Filter property of the DataSet component
Oracle data provider
* Fixed bug with string OUT parameters in Oracle 12.1
SQLServer data provider
* Fixed bug with using the NonBlocking mode from threads
* Fixed bug with Varchar(max), NVarchar(max), Text and NText OUT parameters
* Fixed bug with the AV failure when reading the BLOB fields data in Lazarus
MySQL data provider
* Fixed bug with an "Unknown column" error on Post when RefreshOption = roAfterInsert
PostgreSQL data provider
* Fixed bug with processing UUID fields
* Fixed bug with processing large OID values
* Fixed bug with the incorrect encoding of error messages
* Fixed bug with the incorrect RowsAffected result of the WITH ... statement
* Fixed bug with error when setting the "0" value for a currency field
* Fixed bug with automatic conversion of null values from SQL subqueries to default values
* Fixed bug with processing IDENTITY fields in the PgDump component
* Fixed bug with CanModify = False in the Table component when opening a temporary table
* Fixed bug with using the Dump component with PostgreSQL version 8.1 and earlier
* Fixed bug with executing stored procedures in PostgreSQL version 8.1 and earlier
* Fixed bug with using batch inserts in PostgreSQL version 8.2 and earlier
InterBase data provider
* Firebird 4 is supported
* Fixed bug with executing stored procedures when UseUnicode = True
SQLite data provider
* Added the IntegerAsLargeInt connection specific option
* Fixed bug with mapping VARCHAR columns with length greater than 65,535 to fields of type ftString
NexusDB data provider
* NexusDB 4.50.27 is supported
ODBC data provider
* Fixed bug with re-opening a query which has a parameter of type ftWideString
* Fixed bug with updating boolean columns in MS Access
ASE data provider
* Fixed bug with passing the ApplicationName and ClientHostName parameters to the server
BigQuery data provider
* Added the BigQuery provider
HubSpot data provider
* Added the HubSpot provider

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v9.0.1 Pro for Delphi & C++Builder 11 Alexandria (Retail)

Спойлер: History

9.0.1 13-Sep-21
* RAD Studio 11 Alexandria is supported
* macOS ARM is supported
* Added demo project for FastReport FMX
* Fixed bug with duplicate records when navigating through TVirtualDataSet for which a filter is set
* Fixed bug with persistent fields when saving and then reading data from file to TVirtualTable
* Fixed bug with setting a DateTime value before the year 1800 to TTimeField
* Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
* Fixed bug with memory leak on Locate by field with data type mapping
* Fixed bug with escaping wildcards in the Filter property of the DataSet component
Oracle data provider
* Fixed bug with string OUT parameters in Oracle 12.1
SQLServer data provider
* Fixed bug with using the NonBlocking mode from threads
* Fixed bug with Varchar(max), NVarchar(max), Text and NText OUT parameters
* Fixed bug with the AV failure when reading the BLOB fields data in Lazarus
MySQL data provider
* Fixed bug with an "Unknown column" error on Post when RefreshOption = roAfterInsert
PostgreSQL data provider
* Fixed bug with processing UUID fields
* Fixed bug with processing large OID values
* Fixed bug with the incorrect encoding of error messages
* Fixed bug with the incorrect RowsAffected result of the WITH ... statement
* Fixed bug with error when setting the "0" value for a currency field
* Fixed bug with automatic conversion of null values from SQL subqueries to default values
* Fixed bug with processing IDENTITY fields in the PgDump component
* Fixed bug with CanModify = False in the Table component when opening a temporary table
* Fixed bug with using the Dump component with PostgreSQL version 8.1 and earlier
* Fixed bug with executing stored procedures in PostgreSQL version 8.1 and earlier
* Fixed bug with using batch inserts in PostgreSQL version 8.2 and earlier
InterBase data provider
* Firebird 4 is supported
* Fixed bug with executing stored procedures when UseUnicode = True
SQLite data provider
* Added the IntegerAsLargeInt connection specific option
* Fixed bug with mapping VARCHAR columns with length greater than 65,535 to fields of type ftString
NexusDB data provider
* NexusDB 4.50.27 is supported
ODBC data provider
* Fixed bug with re-opening a query which has a parameter of type ftWideString
* Fixed bug with updating boolean columns in MS Access
ASE data provider
* Fixed bug with passing the ApplicationName and ClientHostName parameters to the server
BigQuery data provider
* Added the BigQuery provider
HubSpot data provider
* Added the HubSpot provider

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v9.1.1 Pro for Delphi & C++Builder 10.3 Rio (Retail)

Спойлер: History

9.1.1 09-Dec-21
* The PoolId connection pool option is added
* Fixed bug with freezing multiply connection pools in threads
* Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
* Fixed bug with using the AsDate property when working with fields of the ftDate type
* Fixed bug with updating the state of records at applying cached updates
* Fixed bug with resetting the specific params
Oracle data provider
* Fixed bug with LONG parameters in Oracle 11 and earlier
* Fixed bug with UnicodeEnvironment in pooling
SQLServer data provider
* Fixed bug with setting the port number to the Server property in Direct mode
* Fixed bug with Varchar(max) and Text OUT parameters in Direct mode
* Fixed bug with describing string params in the Direct mode
MySQL data provider
* Fixed bug with an "Unknown column" error when adding record when RefreshOption = roAfterInsert
PostgreSQL data provider
* PostgreSQL 14 is supported
* OUT parameters in stored procedures for PostgreSQL 14 are supported
* Fixed bug with Access Violation on RefreshRecord after connection switching
* Fixed bug with application name when connection pooling is used
* Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations
* Fixed bug with processing large OID values
InterBase data provider
* The CutOffParams global variable is added
* The WireCompression option for the Connection component is added
* Now, fields of type dtFloat are created for system types INT128, DECFLOAT, and large NUMERIC by default
* Fixed bug with insertion of a string and binary values when UseUnicode set to True
* Fixed bug with an incorrect encoding of table alias names
* Fixed bug with using the AutoDDL property for TUniScript
* Fixed bug with value exceeds the range for valid timestamps when using AsDateTime property
* Fixed bug with Access Violation when DescribeParams is True and using the AsBytes property
* Fixed bug with setting the value of type UInt64 using the Value parameter property
* Fixed bug with inserting a Byte value using the Value parameter property
* Fixed bug with setting the numeric value of the parameter via AsString for TUniStoredProc
* Fixed bug with setting the Connection String
SQLite data provider
* Fixed bug with memory leak when using the julianday() SQL-function in Direct mode
NexusDB data provider
* Block fetch is supported
* Fetch performance is improved
DBF data provider
* FSIZE SQL function is supported
* Autoinc data type for dfVisualFoxPro tables is supported
* Fixed bug with reading logical fields which contains "Y"/"N" values
* Fixed bug with "Invalid field data" when setting a value that exceeds the character field size
ODBC data provider
* Fixed bug with "Range check error" when the field size is greater than MaxInt
* Fixed bug with "Invalid precision value" for dtMemo fields
* Fixed bug with processing UUID fields

Спойлер: Link

password: dumpz.ws

 

[FireWind]

Universal Data Access Components (UniDAC) v9.1.1 Pro for Delphi & C++Builder 10.4 Sydney (Retail)

Спойлер: History

9.1.1 09-Dec-21
* The PoolId connection pool option is added
* Fixed bug with freezing multiply connection pools in threads
* Fixed bug with leading spaces getting trimmed in strings loaded from XML in VirtualTable
* Fixed bug with using the AsDate property when working with fields of the ftDate type
* Fixed bug with updating the state of records at applying cached updates
* Fixed bug with resetting the specific params
Oracle data provider
* Fixed bug with LONG parameters in Oracle 11 and earlier
* Fixed bug with UnicodeEnvironment in pooling
SQLServer data provider
* Fixed bug with setting the port number to the Server property in Direct mode
* Fixed bug with Varchar(max) and Text OUT parameters in Direct mode
* Fixed bug with describing string params in the Direct mode
MySQL data provider
* Fixed bug with an "Unknown column" error when adding record when RefreshOption = roAfterInsert
PostgreSQL data provider
* PostgreSQL 14 is supported
* OUT parameters in stored procedures for PostgreSQL 14 are supported
* Fixed bug with Access Violation on RefreshRecord after connection switching
* Fixed bug with application name when connection pooling is used
* Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations
* Fixed bug with processing large OID values
InterBase data provider
* The CutOffParams global variable is added
* The WireCompression option for the Connection component is added
* Now, fields of type dtFloat are created for system types INT128, DECFLOAT, and large NUMERIC by default
* Fixed bug with insertion of a string and binary values when UseUnicode set to True
* Fixed bug with an incorrect encoding of table alias names
* Fixed bug with using the AutoDDL property for TUniScript
* Fixed bug with value exceeds the range for valid timestamps when using AsDateTime property
* Fixed bug with Access Violation when DescribeParams is True and using the AsBytes property
* Fixed bug with setting the value of type UInt64 using the Value parameter property
* Fixed bug with inserting a Byte value using the Value parameter property
* Fixed bug with setting the numeric value of the parameter via AsString for TUniStoredProc
* Fixed bug with setting the Connection String
SQLite data provider
* Fixed bug with memory leak when using the julianday() SQL-function in Direct mode
NexusDB data provider
* Block fetch is supported
* Fetch performance is improved
DBF data provider
* FSIZE SQL function is supported
* Autoinc data type for dfVisualFoxPro tables is supported
* Fixed bug with reading logical fields which contains "Y"/"N" values
* Fixed bug with "Invalid field data" when setting a value that exceeds the character field size
ODBC data provider
* Fixed bug with "Range check error" when the field size is greater than MaxInt
* Fixed bug with "Invalid precision value" for dtMemo fields
* Fixed bug with processing UUID fields

Спойлер: Link

password: dumpz.ws