ODBC Driver for MySQL Revision History

6.1.0 16-Apr-26

  • Added support for MySQL 9.6
  • Added the ability to use SSL and SSH protocols simultaneously
  • Significantly improved compatibility with Linked Server in MSSMS
  • Improved work with the VECTOR data type
  • Improved work with Numeric/Decimal fields with precision > 38
  • Improved compatibility with the PDO_ODBC PHP extension
  • Improved compatibility with Node.js
  • Fixed an issue with parsing a connection string when its value contained a sequence of SQL comment characters

6.0.0 10-Nov-25

  • 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 Bearer Token authentication when using an HTTP tunnel
  • Improved compatibility with Node.js
  • Improved compatibility with Tableau
  • Improved compatibility with Vectorworks
  • Fixed an issue that caused incorrect connection string parsing on macOS

5.2.0 14-Apr-25

  • 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
  • Fixed an issue with editing File DSN

5.1.2 12-Nov-24

  • Fixed bug with re-activation ODBC driver via another Windows user

5.1.1 28-Mar-24

  • Fixed the issue when establishing a connection with a connection string that contains unsupported parameters

5.1.0 14-Mar-24

  • 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
  • Fixed bug "Inconsistent descriptor information error" when using ADO is fixed
  • Fixed connection timeout setting before opening connection

5.0.1 03-Oct-23

  • Fixed bug with handling the unsigned numeric data type
  • Fixed bug with driver license validation for Linked Server in MSSMS

5.0.0 17-Aug-23

  • Added support for MariaDB 11
  • Improved compatibility with 4D in macOS
  • Fixed bug with SQL executing timeout for HTTP/HTTPS tunneling
  • Fixed bug with getting data in DBeaver
  • Fixed Windows XP installation bug

4.4.0 15-May-23

  • 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
  • Improved compatibility with Alteryx

4.3.0 17-Nov-22

  • Added support for macOS 13 Ventura
  • Improved compatibility with Tableau Prep Builder
  • Improved compatibility with Crystal Reports
  • Improved the SSH connection establishment
  • Fixed bug with using SQLMoreResults function
  • Fixed bug when a connection string parameter value contains a single quote
  • Fixed an issue with adding DSN in PowerShell
  • Fixed an issue with rows deleting

4.2.1 05-Jan-22

  • 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
  • Fixed an issue with updating date and time fields in MS Access

4.1.1 08-Jul-21

  • MSI installer for deploying through GPO is added
  • Bug with executing a SELECT ... INTO OUTFILE statement is fixed

4.0.1 25-May-21

  • Apple Silicon M1 is supported
  • Compatibility with macOS Big Sur is improved
  • Bug with modifying data using the Linked Server is fixed
  • Bug with processing unsigned fields processing when using ADO is fixed

3.1.4 07-Dec-20

  • Minor performance improvements

3.1.3 08-Apr-20

  • Compatibility with Alteryx is improved
  • Compatibility with Power Pivot is improved
  • Compatibility with Visual Basic is improved
  • Compatibility with RStudio is improved
  • Bug with fetching by Bookmark is fixed
  • Bug with modifying data using SQLSetPos is fixed

3.1.2 04-Oct-19

  • 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
  • Bug with executing a SELECT ... INTO OUTFILE statement is fixed

3.0.1 08-Jan-19

  • 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

2.4.9 16-Jul-18

  • Possibility to show used connection string in the connection dialog is added

2.4.8 14-Jun-18

  • 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

2.3.7 26-Feb-18

  • 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

2.2.6 23-Oct-17

  • 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

2.1.5 22-Jun-17

  • Compatibility with Adobe ColdFusion is improved
  • Several issues with data modification in Microsoft SQL Server Management Studio are resolved
  • Now "." is a decimal separator for numbers with floating point by default

2.1.4 29-Nov-16

  • Compatibility with Microsoft SQL Server Reporting Services is improved

2.1.3 26-Oct-16

  • Compatibility with MS Visual Studio is improved
  • 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

2.0.2 05-Apr-16

  • 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

2.0.1 15-Mar-16

  • Linux is supported
  • macOS is supported
  • Support for stored procedures and functions is improved
  • Backward compatibility of SQLExecDirect with ODBC 2.x is improved

1.3.4 06-Jan-16

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

1.2.3 06-Nov-15

  • 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

1.1.2 16-Jul-15

  • Performance is improved
  • Bug with access violation when using ADO is fixed
  • Bug with calling the same SQL statement for several times is fixed

1.0.1 20-May-15

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