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.

Document generated on: 2015-05-16 (revision: 43180)

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