What's New - ODBC Driver for MySQL

New features in ODBC Driver for MySQL 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

New features in ODBC Driver for MySQL 5.1

• Fixed connection timeout setting before opening connection
• Now passwords are stored in an encrypted form in the DSN record
• Added Read Only mode for connection
• Improved compatibility with FileMaker Server for Linux and macOS

New features in ODBC Driver for MySQL 5.0

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

New features in ODBC Driver for MySQL 4.4

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

New features in ODBC Driver for MySQL 4.3

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

New features in ODBC Driver for MySQL 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

New features in ODBC Driver for MySQL 4.1

• MSI installer for deploying through GPO is added

New features in ODBC Driver for MySQL 4.0

• Apple Silicon M1 is supported
• Compatibility with macOS Big Sur is improved

New features in ODBC Driver for MySQL 3.1

• Now ODBC driver is thread-safe
• Now ODBC driver activation does not require administrator privileges
• Work with password-protected private key for SSH protocol is supported
• Improved compatibility with sandboxed applications for macOS
• Support for connection pooling is improved

New features in ODBC Driver for MySQL 3.0

• Now ODBC driver for macOS is distributed as a PKG package
• Now ODBC driver for Linux is distributed as DEB and RPM packages
• Possibility to force the ODBC 2.x behavior is added

New features in ODBC Driver for MySQL 2.4

• MySQL 8 is supported
• Support for sha2_password, caching_sha2_password authentications is added
• Possibility to return String Types as Ansi or Unicode is added
• Compatibility with MS Access is improved
• Compatibility with Tableau is improved
• Compatibility with Omnis Studio is improved
• Compatibility with Power Pivot is improved
• Compatibility with DBeaver is improved

New features in ODBC Driver for MySQL 2.3

• Performance of batch operations is significantly improved
• Retrieving metadata for MySQL 4.1.1 and lower is improved
• The SSHStoragePath connection parameter is added
• Query Timeout option is added

New features in ODBC Driver for MySQL 2.2

• Azure Database for MySQL is supported
• Compatibility with SAS JMP is improved
• Compatibility with MS Power Query is improved
• OUTER JOIN macros in SQL queries are supported
• DateTime macros in SQL queries are supported
• Scalar function macros in SQL queries are supported

New features in ODBC Driver for MySQL 2.1

• Compatibility with MS Visual Studio
• Compatibility with MS FoxPro is improved
• Compatibility with MapInfo is improved
• Compatibility with Libre Office is improved
• Compatibility with Qlik is improved
• Compatibility with Delphi & C++Builder is improved
• MS Access linked tables support is improved

New features in ODBC Driver for MySQL 2.0

• Linux is supported
• macOS is supported
• Support for stored procedures and functions is improved
• Backward compatibility of SQLExecDirect with ODBC 2.x is improved
• Compatibility with MS Excel is improved
• Compatibility with ODBC 2.x is improved
• Bug with Trial expiration in Microsoft SQL Server Management Studio is fixed

New features in ODBC Driver for MySQL 1.3

• Connection via SSL protocol is supported
• Connection via SSH protocol is supported
• Connection via HTTP tunnel is supported
• Compatibility with Power BI Desktop is improved
• Compatibility with Microsoft Visual FoxPro is improved

New features in ODBC Driver for MySQL 1.2

• Compatibility with Microsoft Visual Studio is improved
• Compatibility with Microsoft Office is improved
• Compatibility with Microsoft SQL Server Management Studio is improved
• Compatibility with Crystal Reports is improved
• Compatibility with ClikView is improved

New features in ODBC Driver for MySQL 1.1

• Performance is improved

New features in ODBC Driver for MySQL 1.0

• First release of ODBC Driver for MySQL
• Windows 32-bit is supported
• Windows 64-bit is supported