Что нового?

Welcome to DUMPz.ws - старейший компьютерный форум (c) 2004-2021

Присоединяйтесь к нашему сообществу сейчас, чтобы получить доступ ко всем функциям форума. После регистрации Вы сможете создавать темы, публиковать ответы, общаться в чате с единомышленниками.
Blue
Red
Green
Orange
Voilet
Slate
Dark

Component Devart Universal Data Access Components (UniDAC)

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
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.

Как увидеть ссылки? | How to see hidden 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 Как увидеть ссылки? | How to see hidden links?.

Secure connection​

You can use Как увидеть ссылки? | How to see hidden links? 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

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.3.1 with Source Code
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
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.3.2 for Delphi 10.4.1 Sydney
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)
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 
Последнее редактирование:
  • Like
Реакции: tuc

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.3.2 Pro for Delphi 10.4.1 Sydney (Retail)
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)
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.3.2 Pro for Delphi 10.3 Rio (Retail)
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)
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 
Последнее редактирование:

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.4.1 Pro for Delphi & C++Builder 10.4 Sydney (Retail)
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
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 
Последнее редактирование:

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.4.1 Source for Delphi & C++Builder v6-10.4 and Lazarus
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
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.4.1 Pro for Delphi & C++Builder 10.2-10.3 (Retail)
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
Скрытое содержимое могут видеть только пользователь группы: Premium


password: dumpz.ws
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.4.3 Pro for Delphi & C++Builder 10.4 Sydney (Retail)
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
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws
 

FireWind

Moderator
Регистрация
2 Дек 2005
Сообщения
1,693
Реакции
1,027
Credits
728
Native language | Родной язык
Русский
Universal Data Access Components (UniDAC) v8.4.2 Source for Delphi & C++Builder v6-10.4 and Lazarus
Скрытое содержимое могут видеть только пользователь группы: Premium

password: dumpz.ws