MySQL Connector/ODBC Developer Guide

Chapter 4 Connector/ODBC Installation

This section explains where to download Connector/ODBC, and how to run the installer, copy the files manually, or build from source.

Where to Get Connector/ODBC

You can get a copy of the latest version of Connector/ODBC binaries and sources from our website at https://dev.mysql.com/downloads/Connector/ODBC/.

Choosing Binary or Source Installation Method

You can install the Connector/ODBC drivers using two different methods:

Connector/ODBC binary distributions include an INFO_BIN file that describes the environment and configuration options used to build the distribution. If you installed Connector/ODBC from a binary distribution and experience build-related issues on a platform, it may help to check the settings that were used to build the distribution on that platform. Binary and source distributions include an INFO_SRC file that provides information about the product version and the source repository from which the distribution was produced. This information was added in Connector/ODBC 8.0.14.

Supported Platforms

Connector/ODBC can be used on all major platforms supported by MySQL according to https://www.mysql.com/en/support/supportedplatforms/database.html. This includes Windows, most Unix-like operation systems, and macOS.

Note

On all non-Windows platforms except macOS, the driver is built against unixODBC and is expecting a 2-byte SQLWCHAR, not 4 bytes as iODBC is using. For this reason, the binaries are only compatible with unixODBC; recompile the driver against iODBC to use them together. For further information, see Section 3.2, “ODBC Driver Managers”.

For further instructions, consult the documentation corresponding to the platform where you are installing and whether you are running a binary installer or building from source:

Platform Binary Installer Build from Source
Windows Installation Instructions Build Instructions
Unix/Linux Installation Instructions Build Instructions
macOS Installation Instructions

Choosing Unicode or ANSI Driver

Connector/ODBC offers the flexibility to handle data using any character set through its Unicode-enabled driver, or the maximum raw speed for a more limited range of character sets through its ANSI driver. Both kinds of drivers are provided in the same download package, and are both installed onto your systems by the installation program or script that comes with the download package. Users who install Connector/ODBC and register it to the ODBC manager manually can choose to install and register either one or both of the drivers; the different drivers are identified by a w (for wide characters) for the Unicode driver and a for the ANSI driver at the end of the library names. For example, myodbc8w.dll versus myodbc8a.dll, or libmyodbc8w.so versus libmyodbc8a.so.

Note

Related: The previously described file names contain an "8", such as myodbc8a.dll, which means they are for Connector/ODBC 8.x. File names with a "5", such as myodbc5a.dll, are for Connector/ODBC 5.x.