Universal Data Access Components (UniDAC) Releases

• Added support for RAD Studio 13 Florence Release 2.
• Improved support for the Arm64EC target platform.
• Added support for Lazarus 4.8.
• Added the voAssignReadOnly and voAssignRequired options to the VirtualTable component to control field attributes when calling Assign().
• Improved handling of the UpdatingTable property when a query contains multiple references to the same table.
• Removed the deprecated AutoCommit property from the Script component.
• Removed the insecure MD5 hashing algorithm from the tunnel.php script.

Oracle data provider

• Added the AutoCommit specific option to the SQL, Table, Query, StoredProc, and Script components.

SQL Server data provider

• Added support for Microsoft SQL Server 2025.
• Added support for Always Encrypted.

InterBase data provider

• Added the AutoCommit specific option to the Script component.
• Improved generation of INSERT and UPDATE statements when DMLRefresh is enabled.
• Added support for the TrustedAuthentication specific option in TUniConnection.
• Added support for Wait mode and Lock timeout in the transaction component.

MySQL data provider

• Added support for MySQL 9.7.x.
• Added support for generated columns.
• Added support for handling the new ER_CLIENT_INTERACTION_TIMEOUT error packet.
• Added support for the authentication_ldap_sasl authentication plugin with the GSSAPI mechanism.
• Improved support for the GSSAPI authentication plugin.

PostgreSQL data provider

• Added the AutoCommit specific option to the SQL, Table, Query, StoredProc, Script, and Dump components.
• Added the ReadOnly connection option.
• Added the SNI SSL option to the Connection component.
• Added the ClientCharset option to the Connection component.
• Added support for the pv32 protocol in the Connection component.
• Added the Matview table metadata kind to the TUniMetaData component.

NexusDB data provider

• Added support for NexusDB 4.75.20.
• Added support for read-only transactions.
• Improved data loading performance with TUniLoader.

DBF data provider

• Improved compatibility with the Codebase format.
• Improved the AllFieldsAsNullable specific option when working with Visual FoxPro.

Access data provider

• Improved compatibility with the Access 97 (Microsoft Jet 3) format.

Salesforce data provider

• Added support for server-to-server authentication.

• Fixed an issue with incorrect field ordering when using CloneCursor().

Oracle data provider

• Fixed an issue that caused TOraAlerter to hang when the connection was lost.

InterBase data provider

• Fixed an issue with the ExtendedFieldsInfo option when working with InterBase.
• Fixed an issue that caused the "arithmetic exception, numeric overflow, expected length x, actual y" error when opening tables with computed fields.

MySQL data provider

• Fixed an issue with incorrect INSERT statement generation when a SELECT statement included fields from multiple tables.
• Fixed an issue that caused the "Record was changed by another user" error when calling the TMyTable.Lock() method.
• Fixed an issue that occurred when both FlatBuffers and UseUnicode were set to True.

PostgreSQL data provider

• Fixed an issue where the Script component always ran with AutoCommit set to True, regardless of the specified AutoCommit value.
• Fixed an issue with using functions when FetchAll is set to False and CursorWithHold is set to True.
• Fixed an issue with using parameters and AsFloat for BIGINT fields.
• Fixed an issue that caused prepared statements to accumulate on the server.

SQLite data provider

• Fixed an issue that caused incorrect results when opening a parameterized dataset with AutoPrepare and AdvancedTypeDetection enabled.

MongoDB data provider

• Fixed several issues with Decimal128 data type handling.

DBF data provider

• Fixed an issue with updating LOGICAL fields.
• Fixed an issue that caused an assertion failure when updating a record.

Excel data provider

• Fixed an issue that caused the "vtable constructor failed" exception when opening a workbook.

• PostgreSQL data provider
  • Replaced the UseSystemLocale Boolean connection option with the SystemLocale charset option.
• NexusDB data provider
  • Added support for the DatabaseReadOnly option on both Remote and Embedded servers.

• Fixed a bug that caused the "Invalid package handle" error when closing the IDE on Windows on Arm.
• Resolved an issue that could cause an AccessViolation when changing the provider in the Connection component with DisconnectedMode enabled.
• Fixed a bug that caused incorrect query results in the VirtualQuery component when a BDE dataset was used as the data source.
• Oracle data provider
  • Fixed an issue with time zone conversion for TIMESTAMP WITH TIME ZONE values.
• SQLServer data provider
  • Fixed an issue with handling names that contain consecutive dots in Direct mode.
• InterBase data provider
  • Fixed an issue with updating datasets that use composite primary keys containing identity columns.
• MySQL data provider
  • Fixed a bug that caused the ReceiveHeader: Net packets out of order error when wait_timeout expired.
  • Fixed a bug in TMyScript script execution when the default delimiter (;) was used and the script contained the DELIMITER ;; statement.
• PostgreSQL data provider
  • Fixed a bug that caused the "Incompatible types" error.
  • Resolved an issue related to parameter handling.
  • Fixed an issue with saving parameters in UniSQL.
  • Fixed an Access Violation that could occur when using connection pooling with master-detail UUID fields.
  • Resolved an issue that could cause an AccessViolation when using C++Builder Windows 64-bit (Modern) compilation.
• SQLite data provider
  • Fixed an error that occurred when compiling the LiteStaticCall unit.
• DB2 data provider
  • Resolved an issue with missing table fields on the SQL Generator tab of the Query Editor window.

• Added support for RAD Studio 13.1 Florence.
• Added support for the Arm64EC target platform.
• Added support for Lazarus 4.6.
• Added the "For the current user/For all users" option during installation.
• Added masking of the Password property in the Connection component to prevent it from being stored in memory as plain text.
• Added the GetWhere method to the TCustomDADataSet component.
• Added the DeleteOrderBy method to the TCustomDADataSet component.
• Added the RangeFieldCount property to TCustomDADataSet to specify the number of indexed fields used for range setting.
• Added the AutoClose option to TCustomDADataSet to control automatic closing of a dataset when its associated ClientDataSet is closed.
• Added support for cloning a structure of the VirtualTable component with the Fields.Assign method.
• Improved performance of the VirtualQuery component when using a TDataSet as a source.
• Oracle data provider
  • Added support for Oracle 26ai.
  • Added support for the JSON data type in Oracle 21c and later.
  • Improved performance of Oracle homes list detecting.
• SQL Server data provider
  • Added the DescribeFields option to control the call to the sp_describe_first_result_set procedure.
  • Added the CommandTimeout option to TUniConnection specific options.
• InterBase data provider
  • Added support for Firebird 3 functions.
  • Added support for the wait_time and read_consistency parameters for TPB.
  • Added support for the isc_dpb_connect_timeout, isc_dpb_dummy_packet_interval, and isc_dpb_garbage_collect parameters for DPB.
  • Added the FloatAsSingle specific option for the Connection component.
  • Added the UseReadConsistency specific option for the Connection component.
  • Added the ConnectionConfigOverrides specific option for the Connection component.
  • Added support for "GENERATED BY DEFAULT AS IDENTITY" fields.
  • Improved working with DPB, TPB and SPB.
• MySQL data provider
  • Added support for MySQL 9.6.
  • Added the SetFieldsReadOnly option to the TUniDump component to allow adding read-only fields in INSERT statements during backup.
  • Added the Delimiter option to the TUniDump component to set a custom delimiter for stored procedure and trigger backup.
• PostgreSQL data provider
  • Added support for PostgreSQL 18.
  • Added support for protocol 3.2.
  • Added support for virtual generated columns.
  • Added support for OAUTHBEARER authentication.
  • Added the CurrentTimeZone specific connection option.
  • Added the UseSystemLocale specific connection option.
• SQLite data provider
  • Added support for vector fields via the sqlite-vec and sqlite-vector extensions.
  • Added the LimitLength specific option to set the SQLITE_LIMIT_LENGTH runtime limit.
  • Added the LimitExprDepth specific option to set the SQLITE_LIMIT_EXPR_DEPTH runtime limit.
• ASE data provider
  • Added the DescribeParams specific option for TUniTable, TUniQuery, and TUniSQL components.
• NexusDB data provider
  • Added the SkipSetIndexServerCursor option to avoid setting indexes when ServerCursorUsed is used.
• DBF data provider
  • Added the ReadOnly connection option.
• Access data provider
  • Added SharedMode and SharedTimeout connection options to enable the concurrent use of the same database from multiple applications.
    • Excel data provider
    • Added support for the CREATE RANGE statement to refer to a range of cells as a database object.
    • Added the ExactFieldLength connection option to set the length of a string field to an exact value depending on the data.
• BigQuery data provider
  • Added support for Service Account Authentication using JSON.

• Fixed an issue with installing the Professional Edition with Source Code in Lazarus.
• Fixed an issue that caused incorrect record sorting in a dataset when both ORDER BY and IndexFieldNames are used.
• Fixed an issue with the ConnectString property in the Connection component when its value contained a sequence of SQL comment characters.
• Fixed an issue in tunnel.php that required establishing a tunnel connection in a browser first.
• Fixed an issue with freeing BLOB values when updating a record in the VirtualQuery component .
• Oracle data provider
  • Fixed an issue that caused a compilation error when ODAC and UniDAC Express were installed simultaneously .
• SQL Server data provider
  • Fixed an issue where parameter values were lost during Insert operations .
• InterBase data provider
  • Fixed an issue with an Invalid pointer operation on destroying a dataset.
  • Fixed an issue that caused the "Block Option isc_tpb_rec_version is not valid if isc_tpb_read_consistency was used previously in TPB" error for Firebird 4 and later.
  • Fixed an issue with compiling InterBaseUniProvider for Android 32-bit in RAD Studio 13 Florence and RAD Studio 12 Athens Release 3
• MySQL data provider
  • Fixed an issue with executing SHOW COLUMNS for MySQL 4.11.x when UseUnicode = True.
• SQLite data provider
  • Fixed an issue that caused the "Incorrect parameter" exception when executing a query with parameters.
• ASE data provider
  • Fixed an issue with detecting the server character set.
• DBF data provider
  • Fixed an issue with incorrect index data update when inserting a record.
• Access data provider
  • Fixed an issue that caused the "BCD overflow" exception when reading Decimal fields.
• Excel data provider
  • Fixed several issues with reading tables and named ranges when opening XLSX and XLSM workbooks.
  • Fixed several issues with opening an XLS workbook.