Chapter 5 Configuring Connector/ODBC

Table of Contents

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

Before you connect to a MySQL database using the Connector/ODBC driver, you configure an ODBC Data Source Name (DSN). The DSN associates the various configuration parameters required to communicate with a database to a specific name. You use the DSN in an application to communicate with the database, rather than specifying individual parameters within the application itself. DSN information can be user-specific, system-specific, or provided in a special file. ODBC data source names are configured in different ways, depending on your platform and ODBC driver.