MySQL Connector/ODBC 5.2

This ODBC Driver is provided by MySQL. The main functionality of the driver is contained in the file myodbc5.dll.

Include "Driver={MySQL ODBC 5.2 ANSI Driver}" in the connection string to use this driver.

Description

From version 5.2.5 driver name changed:

  • MySQL ODBC 5.2a Driver → MySQL ODBC 5.2 ANSI Driver
  • MySQL ODBC 5.2w Driver → MySQL ODBC 5.2 UNICODE Driver

Connector/ODBC 5.2 is a partial rewrite of the of the Connector/ODBC 3.51 code base and is designed to work with all versions of MySQL from 4.1. It's a complete implementation of the ODBC Core interface, plus more Level 1 and Level 2 functionality of the ODBC specification than that currently supported by Connector/ODBC 3.51.

Some impovements over the 3.51 release includes:

  • Improved support on Windows 64-bit platforms.
  • Full Unicode support at the driver level.
  • Support for the SQL_NUMERIC_STRUCT datatype, which provides easier access to the precise definition of numeric values.
  • Native Windows setup library. (Replaces the Qt library based interface for configuring DSN information within the ODBC Data Sources application.)
  • Support for the ODBC descriptor, which improves the handling and metadata of columns and parameter data.
  • To get all functionality from the ODBC 5.2 driver (like transaction support) you should use it against MySQL 4.1 or above.

More info about this driver can be found at the MySQL product page.

Download

This ODBC Driver, MySQL Connector/ODBC 5.2, can be downloaded here.

Connection Strings

The MySQL Connector/ODBC 5.2 driver can be used to connect to the following data sources by using the following connection string references:

MySQL