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 5.x DSN on Windows
5.3.2 Configuring a Connector/ODBC 5.x DSN on Windows, Using the Command Line
5.3.3 Troubleshooting ODBC Connection Problems
5.4 Configuring a Connector/ODBC DSN on OS X
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 OS X
5.8.3 Enabling ODBC Tracing on Unix
5.8.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.