Documentation Home
MySQL Connector/ODBC Developer Guide
Related Documentation Download this Manual

MySQL Connector/ODBC Developer Guide

Abstract

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.

MySQL Connector/ODBC 8.0 is recommended for use with MySQL Server 8.0, 5.7, and 5.6. Please upgrade to MySQL Connector/ODBC 8.0.

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 the MySQL Forums, where you can discuss your issues with other MySQL users.

Licensing information.  This product may include third-party software, used under license. MySQL Connector/ODBC Community License Information User Manual has information about licenses relating to Connector/ODBC community releases up to and including version 5.3. MySQL Connector/ODBC Commercial License Information User Manual has information about licenses relating to Connector/ODBC commercial releases up to and including version 5.3. MySQL Connector/ODBC 8.0 Community License Information User Manual has information about licenses relating to Connector/ODBC community releases in the 8.0 release series. MySQL Connector/ODBC 8.0 Commercial License Information User Manual has information about licenses relating to Connector/ODBC commercial releases in the 8.0 release series.

Document generated on: 2020-07-04 (revision: 66460)

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 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 a DEB Distribution
4.2.4 Installing Connector/ODBC from an RPM Distribution
4.3 Installing Connector/ODBC on macOS
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 macOS
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 DSN on Windows with the ODBC Data Source Administrator GUI
5.3.2 Configuring a Connector/ODBC DSN on Windows, Using the Command Line
5.3.3 Troubleshooting ODBC Connection Problems
5.4 Configuring a Connector/ODBC DSN on macOS
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 macOS
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 OpenOffice.org
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 and the Application Both Use OpenSSL
8.4 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