Release notes for ODBC Driver for MySQL

Version 6.0

• Added a graphical interface for configuring the driver on macOS and Linux.
• Added support for MariaDB 12.
• Added support for the Vector data type.
• Added support for the UUID data type in MariaDB 10.7 and later.
• Added support for the INET4 and INET6 data types in MariaDB 10.10 and later.
• Added support for the Bearer Token authentication when using the HTTP tunnel.
• Improved compatibility with Visual Basic in Visual Studio.
• Improved compatibility with Linked Server in SQL Server.
• Improved compatibility with Alteryx.

Version 5.2

• Added support for MySQL 9.
• Added support for password-protected private keys for the SSL protocol.
• Improved compatibility with Crystal Reports.
• Improved compatibility with Microsoft Query.

Version 5.1

• Fixed connection timeout setting before opening a connection.
• Added the storage of passwords in an encrypted form in the DSN record.
• Added the read-only mode for the connection.
• Improved compatibility with FileMaker Server on macOS and Linux.

Version 5.0

• Added support for MariaDB 11.
• Improved compatibility with 4D on macOS.

Version 4.4

• Added support for the SELECT TOP clause for Linked Server in MSSMS.
• Added support for the SQL_ATTR_MAX_ROWS attribute.
• Improved compatibility with Visual Basic in Visual Studio.

Version 4.3

• Added support for macOS 13 Ventura.
• Improved compatibility with Tableau Prep Builder.
• Improved compatibility with Crystal Reports.
• Improved the SSH connection establishment.

Version 4.2

• Added support for Windows 11.
• Added support for MariaDB 10.6.
• Improved compatibility with FICO Mosel.
• Improved compatibility with FileMaker.
• Improved compatibility with JMP on macOS.
• Improved support for an ODBC installer on Windows 2000.

Version 4.1

• Added MSI installer for deployment via Group Policy (GPO).

Version 4.0

• Added support for Apple Silicon M1.
• Improved compatibility with macOS Big Sur.

Version 3.1

• Improved thread-safety of the ODBC driver.
• Added the possibility of activation of the ODBC driver without administrator privileges.
• Added support for password-protected private keys for the SSH protocol.
• Improved compatibility with sandboxed applications on macOS.
• Improved support for connection pooling.

Version 3.0

• Added macOS distribution of the ODBC driver as a PKG package.
• Added Linux distribution of the ODBC driver as DEB and RPM packages.
• Added the possibility of forcing the ODBC 2.x behavior.

Version 2.4

• Added support for MySQL 8.
• Added support for the sha2_password and caching_sha2_password authentications.
• Added the possibility to return String Types as Ansi or Unicode.
• Improved compatibility with MS Access.
• Improved compatibility with Tableau.
• Improved compatibility with Omnis Studio.
• Improved compatibility with Power Pivot.
• Improved compatibility with DBeaver.

Version 2.3

• Improved performance of batch operations.
• Improved metadata retrieval performance for MySQL 4.1.1 and earlier.
• Added the SSHStoragePath connection parameter.
• Added the Query Timeout option.

Version 2.2

• Added support for Azure Database for MySQL.
• Improved compatibility with SAS JMP.
• Improved compatibility with MS Power Query.
• Added support for the OUTER JOIN macros in SQL queries.
• Added support for the DateTime macros in SQL queries.
• Added support for the Scalar function macros in SQL queries.

Version 2.1

• Added compatibility with MS Visual Studio.
• Improved compatibility with MS FoxPro.
• Improved compatibility with MapInfo.
• Improved compatibility with Libre Office.
• Improved compatibility with Qlik.
• Improved compatibility with Delphi & C++Builder.
• Improved support for MS Access linked tables.

Version 2.0

• Added support for Linux.
• Added support for macOS.
• Improved support for stored procedures and functions.
• Improved backward compatibility of SQLExecDirect with ODBC 2.x.
• Improved compatibility with MS Excel.
• Improved compatibility with ODBC 2.x.
• Fixed the Trial expiration in Microsoft SQL Server Management Studio.

Version 1.3

• Added support for a connection via the SSL protocol.
• Added support for a connection via the SSH protocol.
• Added support for a connection via the HTTP tunnel.
• Improved compatibility with Power BI Desktop.
• Improved compatibility with Microsoft Visual FoxPro.

Version 1.2

• Improved compatibility with Microsoft Visual Studio.
• Improved compatibility with Microsoft Office.
• Improved compatibility with Microsoft SQL Server Management Studio.
• Improved compatibility with Crystal Reports.
• Improved compatibility with ClikView.

Version 1.1

• Improved performance.

Version 1.0

• First release of Devart ODBC Driver for MySQL.
• Added support for:
  • Windows 32-bit
  • Windows 64-bit