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 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. 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.
Document generated on: 2023-05-24 (revision: 75721)
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 Authentication Options
- 5.9 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