MySQL Connector/ODBC Developer Guide


This manual describes how to install and configure MySQL Connector/ODBC, the driver that enables ODBC applications to communicate with MySQL servers, and how to use it to develop database applications.

For notes detailing the changes in each release of Connector/ODBC, see MySQL Connector/ODBC Release Notes.

For legal information, see the Legal Notices.

For help with using MySQL, please visit either the MySQL Forums or MySQL Mailing Lists, where you can discuss your issues with other MySQL users.

For additional documentation on MySQL products, including translations of the documentation into other languages, and downloadable versions in variety of formats, including HTML and PDF formats, see the MySQL Documentation Library.

Document generated on: 2016-02-05 (revision: 46394)

Table of Contents

Preface and Legal Notices
1 Introduction to MySQL Connector/ODBC
2 Connector/ODBC Versions
3 General Information About ODBC and Connector/ODBC
3.1 Connector/ODBC Architecture
3.2 ODBC Driver Managers
4 Connector/ODBC Installation
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
5 Configuring Connector/ODBC
5.1 Overview of Connector/ODBC Data Source Names
5.2 Connector/ODBC Connection Parameters
5.3 Configuring a Connector/ODBC DSN on Windows
5.3.1 Configuring a Connector/ODBC 5.x DSN on Windows
5.3.2 Configuring a Connector/ODBC 5.x DSN on Windows, Using the Command Line
5.3.3 Troubleshooting ODBC Connection Problems
5.4 Configuring a Connector/ODBC DSN on OS X
5.5 Configuring a Connector/ODBC DSN on Unix
5.6 Connecting Without a Predefined DSN
5.7 ODBC Connection Pooling
5.8 Getting an ODBC Trace File
5.8.1 Enabling ODBC Tracing on Windows
5.8.2 Enabling ODBC Tracing on OS X
5.8.3 Enabling ODBC Tracing on Unix
5.8.4 Enabling a Connector/ODBC Log
6 Connector/ODBC Examples
6.1 Basic Connector/ODBC Application Steps
6.2 Step-by-step Guide to Connecting to a MySQL Database through Connector/ODBC
6.3 Connector/ODBC and Third-Party ODBC Tools
6.4 Using Connector/ODBC with Microsoft Access
6.4.1 Exporting Access Data to MySQL
6.4.2 Importing MySQL Data to Access
6.4.3 Using Microsoft Access as a Front-end to MySQL
6.5 Using Connector/ODBC with Microsoft Word or Excel
6.6 Using Connector/ODBC with Crystal Reports
6.7 Connector/ODBC Programming
6.7.1 Using Connector/ODBC with Visual Basic Using ADO, DAO and RDO
6.7.2 Using Connector/ODBC with .NET
7 Connector/ODBC Reference
7.1 Connector/ODBC API Reference
7.2 Connector/ODBC Data Types
7.3 Connector/ODBC Error Codes
8 Connector/ODBC Notes and Tips
8.1 Connector/ODBC General Functionality
8.1.1 Obtaining Auto-Increment Values
8.1.2 Dynamic Cursor Support
8.1.3 Connector/ODBC Performance
8.1.4 Setting ODBC Query Timeout in Windows
8.2 Connector/ODBC Application-Specific Tips
8.2.1 Using Connector/ODBC with Microsoft Applications
8.2.2 Using Connector/ODBC with Borland Applications
8.2.3 Using Connector/ODBC with ColdFusion
8.2.4 Using Connector/ODBC with
8.2.5 Using Connector/ODBC with Sambar Server
8.2.6 Using Connector/ODBC with Pervasive Software DataJunction
8.2.7 Using Connector/ODBC with SunSystems Vision
8.3 Connector/ODBC Errors and Resolutions (FAQ)
9 Connector/ODBC Support
9.1 Connector/ODBC Community Support
9.2 How to Report Connector/ODBC Problems or Bugs
9.3 How to Submit a Connector/ODBC Patch
A Licenses for Third-Party Components
A.1 GNU Libtool License
A.2 OpenSSL v1.0 License