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 9.1, which includes the functionality of the Unicode driver and the ANSI driver.
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 full Unicode compliance.
For more information on the ODBC API standard and how to use it, refer to http://support.microsoft.com/kb/110093.
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 https://dev.mysql.com/doc/.
Typically, you need to install Connector/ODBC only on Windows machines. For Unix and macOS, you can use the native MySQL network or named pipes to communicate with your MySQL database. You may need Connector/ODBC for Unix or macOS 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 notes detailing the changes in each release of Connector/ODBC, see MySQL Connector/ODBC Release Notes.
Key Connector/ODBC topics include:
Installing Connector/ODBC: Section 5.4, “Connector/ODBC Installation”.
The configuration options: Section 5.5.2, “Connector/ODBC Connection Parameters”.
An example that connects to a MySQL database from a Windows host: Section 5.6.2, “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 5.6.4, “Using Connector/ODBC with Microsoft Access”.
General tips and notes, including how to obtain the last auto-increment ID: Section 5.8.1, “Connector/ODBC General Functionality”.
Application-specific usage tips and notes: Section 5.8.2, “Connector/ODBC Application-Specific Tips”.
A FAQ (Frequently Asked Questions) list: Section 5.8.4, “Connector/ODBC Errors and Resolutions (FAQ)”.
Additional Connector/ODBC support options: Section 5.9, “Connector/ODBC Support”.