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 8.0 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.1 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.1 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-11-05 (revision: 80192)
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
- 4 Connector/ODBC Installation
- 4.1 Installing Connector/ODBC on Windows
- 4.2 Installing Connector/ODBC on Unix-like Systems
- 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.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
- 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.5 Using Connector/ODBC with Microsoft Word or Excel
- 6.6 Using Connector/ODBC with Crystal Reports
- 6.7 Connector/ODBC Programming
- 7 Connector/ODBC Reference
- 8 Connector/ODBC Notes and Tips
- 8.1 Connector/ODBC General Functionality
- 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