Description

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.

11.0.1 26-Dec-25

• Added support for Lazarus 4.4
• Extended support for the Connection component's AllowImplicitConnect property to the Script and SQL components
• Fixed an AV failure that could occur when reading a persistent TWideStringField in Delphi 7
• Fixed an issue where XML fields could be saved incorrectly when using the dataset component's SaveToXML method
• Fixed an issue with registering help files in RAD Studio 13
• Fixed an access violation that could occur when reopening the master table with LocalMasterDetail set to True
• Fixed a possible nil reference to Encoding in the TParser constructor
• Fixed an issue where the VirtualQuery component could return incorrect data after calling Refresh

Oracle data provider

• Fixed an issue with reading values to TLargeintField in the scrollable cursors

SQLServer data provider

• Fixed a hang that could occur when using pessimistic locking in Pooling mode (SQLServer provider)

InterBase data provider

• Improved metadata retrieval for stored procedures and functions via TUniMetaData
• Switched to the new default read committed mode, READ COMMITTED READ CONSISTENCY, for Firebird 4 and later
• Fixed an issue with handling the ibcFloat data type
• Fixed an issue with writing BLOB data when CacheBlobs was set to False
• Fixed an issue where the global CutOffParams variable was used when UseUnicode was set to False
• Fixed a �Conversion error from string �1�� issue when DMLRefresh and BooleanDomainFields were set to True
• Fixed an issue where parameter values could be truncated in Firebird 5 and later when UseUnicode was set to True
• Fixed an issue where INSERT statements could be generated incorrectly for master/detail relationships configured with KeyFields and KeyGenerator

PostgreSQL data provider

• Improved handling of the SET TIMEZONE command
• Fixed an issue where creating a VIEW in UniQuery could fail when UniDirectional was set to True
• Fixed an issue where transaction handling for SELECT statements without a FROM clause could be incorrect when AutoCommit was set to False

SQLite data provider

• Fixed an issue with Unicode database file names on macOS in Direct mode

Access data provider

• Fixed multiple issues with handling AutoNumber columns of the Replication ID type

ODBC data provider

Added the IgnoreWarnings provider-specific option to control how SQL_SUCCESS_WITH_INFO result codes are processed

Additional Information