Documentation Home
MySQL Connector/ODBC Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.7Mb
PDF (A4) - 1.7Mb


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.

The latest MySQL Connector/ODBC version is recommended for use with MySQL Server version 5.7 and higher.

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. If you are using a Commercial release of MySQL Connector/ODBC, see the MySQL Connector/ODBC 9.0 Commercial License Information User Manual or MySQL Connector/ODBC 8.0 Commercial License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this Commercial release. If you are using a Community release of MySQL Connector/ODBC, see the MySQL Connector/ODBC 9.0 Community License Information User Manual or MySQL Connector/ODBC 8.0 Community License Information User Manual for licensing information, including licensing information relating to third-party software that may be included in this Community release.

Document generated on: 2024-07-03 (revision: 78965)

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.1.2 Installing the Windows Connector/ODBC Debug Packages
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 OpenTelemetry Tracing Support
5.9 Authentication Options
5.10 Getting an ODBC Trace File
5.10.1 Enabling ODBC Tracing on Windows
5.10.2 Enabling ODBC Tracing on macOS
5.10.3 Enabling ODBC Tracing on Unix
5.10.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 Configuring Catalog and Schema Support
8.1.4 Connector/ODBC Performance
8.1.5 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 Pervasive Software DataJunction
8.2.6 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