Devart Excel Add-in Database Pack 3.0.0

Released: Jun 12, 2026

3.0.0 버젼 업데이트

기능

  • Added support for Excel 2024.

MySQL

  • Added support for MariaDB 12.
  • Added support for the INET6 data type in MariaDB.
  • Added support for the UUID data type in MariaDB.
  • Added support for SingleStore (formerly MemSQL).
  • Added support for modern SSH encryption and key exchange algorithms.

Oracle

  • Added support for the Oracle Database 26ai.
  • Added support for the JSON data type in Oracle Database 21c, 23ai, and 26ai.
  • Added support for the BOOLEAN data type in Oracle Database 23ai and 26ai.
  • Added support for long passwords in Oracle 23ai and 26ai.
  • Added support for modern SSH encryption and key exchange algorithms.

PostgreSQL

  • Added support for PostgreSQL 17 and 18.
  • Added the Use Session Timezone connection string parameter to control whether PostgreSQL date/time values are converted using the current session time zone.
  • Added support for modern SSH encryption and key exchange algorithms.

SQL Server

  • Added support for Microsoft SQL Server 2025.

수정사항

  • Fixed multiple issues related to API support for cloud data sources.
  • Fixed an issue with displaying Unicode characters during installation.

MySQL

  • Fixed an issue with reading large Int64 values.
  • Fixed an issue that caused the 'Bad handshake' error when opening a connection.
  • Fixed an issue that caused the error: 'SSL connection error: Cannot load client private key.'.

Oracle

  • Resolved a memory leak issue occurring when repeatedly establishing connections in the OCI mode.
  • Fixed an issue that caused an AccessViolationException when reading CLOB/NCLOB data in the OCI mode.
  • Fixed an issue causing the "Offset must be within plus or minus 14 hours" error when reading TIMESTAMP WITH TIMEZONE values.
  • Fixed an issue with XMLTYPE handling in Direct mode when Unicode=False.

PostgreSQL

  • Fixed an issue that caused the 'SSL connection error: Cannot load client private key.' error.
  • Fixed an issue that caused the 'Authentication failed in ssl mode' error when opening a connection.
  • Fixed an issue that caused the 'Unsupported frontend protocol' error when connecting to PostgreSQL 8.0.
  • Fixed an issue with saving MONEY data type values.
  • Fixed an issue with negative MONEY values displayed in accounting format when using protocol 2.
  • Fixed an issue with trailing zeros in the fractional part of NUMERIC data type.
  • Fixed incorrect handling of TIMESTAMPTZ values when the Use Session Timezone connection string parameter was set to True.

SQLite

  • Fixed an issue with using the URI format in the Data Source connection string parameter.