Chapter 4 Connector/ODBC Installation

Table of Contents

4.1 Installing Connector/ODBC on Windows
4.1.1 Installing the Windows Connector/ODBC Driver Using an Installer
4.1.2 Installing the Windows Connector/ODBC Driver Using the Zipped DLL Package
4.2 Installing Connector/ODBC on Unix-like Systems
4.2.1 Installing Connector/ODBC Using the MySQL Yum Repository
4.2.2 Installing Connector/ODBC from a Binary Tarball Distribution
4.2.3 Installing Connector/ODBC from an RPM Distribution
4.3 Installing Connector/ODBC on OS X
4.4 Building Connector/ODBC from a Source Distribution on Windows
4.5 Building Connector/ODBC from a Source Distribution on Unix
4.6 Building Connector/ODBC from a Source Distribution on OS X
4.7 Installing Connector/ODBC from the Development Source Tree

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 http://dev.mysql.com/downloads/connector/odbc/.

For more information about Connector/ODBC, visit http://www.mysql.com/products/myodbc/.

For more information about licensing, visit http://www.mysql.com/company/legal/licensing/.

Choosing Binary or Source Installation Method

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

Supported Platforms

Connector/ODBC can be used on all major platforms supported by MySQL. You can install it on:

Note

On all non-Windows platforms except OS X, 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:

PlatformBinary InstallerBuild from Source
WindowsInstallation InstructionsBuild Instructions
Unix/LinuxInstallation InstructionsBuild Instructions
OS XInstallation 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, myodbc5w.dll versus myodbc5a.dll, or libmyodbc5w.so versus libmyodbc5a.so.