The MySQL Connector/ODBC is the name for the family of MySQL ODBC drivers (previously called MyODBC drivers) that provide access to a MySQL database using the industry standard Open Database Connectivity (ODBC) API. This reference covers Connector/ODBC 5.2, which includes the functionality of the Unicode driver and the ANSI driver, which formerly were split between Connector/ODBC 5.1 and Connector/ODBC 3.51.
MySQL Connector/ODBC provides both driver-manager based and native interfaces to the MySQL database, with full support for MySQL functionality, including stored procedures, transactions and, with Connector/ODBC 5.1 and higher, full Unicode compliance.
For more information on the ODBC API standard and how to use it, refer to
The application development section of the ODBC API reference assumes a good working knowledge of C, general
DBMS, and a familiarity with MySQL. For more information about MySQL functionality and its syntax, refer to
Typically, you need to install Connector/ODBC only on Windows machines. For Unix and Mac OS X, you can use the native MySQL network or named pipes to communicate with your MySQL database. You may need Connector/ODBC for Unix or Mac OS X if you have an application that requires an ODBC interface to communicate with the database. Applications that require ODBC to communicate with MySQL include ColdFusion, Microsoft Office, and Filemaker Pro.
For release notes detailing the changes in each release of Connector/ODBC, see
Installing Connector/ODBC: Section 21.1.3, "Connector/ODBC Installation".
The configuration options: Section 220.127.116.11, "Connector/ODBC Connection Parameters".
An example that connects to a MySQL database from a Windows host: Section 18.104.22.168, "Step-by-step Guide to Connecting to a MySQL Database through Connector/ODBC".
An example that uses Microsoft Access as an interface to a MySQL database: Section 22.214.171.124, "Using Connector/ODBC with Microsoft Access".
General tips and notes, including how to obtain the last auto-increment ID: Section 126.96.36.199, "Connector/ODBC General Functionality".
Application-specific usage tips and notes: Section 188.8.131.52, "Connector/ODBC Application-Specific Tips".
A FAQ (Frequently Asked Questions) list: Section 184.108.40.206, "Connector/ODBC Errors and Resolutions (FAQ)".
Additional Connector/ODBC support options: Section 21.1.8, "Connector/ODBC Support".