MySQL Connector/ODBC

Last updated
MySQL Connector/ODBC
Developer(s) Oracle Corporation (originally MySQL AB)
Operating system Microsoft Windows, Linux, macOS, Unix-like
Platform Cross-platform
Type Database driver
License GPLv2 with FOSS License Exception
Website MySQL Connector/ODBC downloads

MySQL Connector/ODBC (formerly MyODBC) is an ODBC driver developed by Oracle Corporation for connecting ODBC-enabled applications to MySQL databases. [1] It was originally created by MySQL AB and has been maintained by Oracle since the acquisition of Sun Microsystems in 2010. [2]

Contents

Overview

MySQL Connector/ODBC enables any application supporting ODBC—including business intelligence tools, office suites, custom applications, and legacy systems—to access, query, and manage MySQL databases using the ODBC interface. [1] [3]

Platform support and installation

MySQL Connector/ODBC is available for Microsoft Windows, Linux, macOS, and other Unix-like systems. [4] Both 32-bit and 64-bit builds are provided, depending on the system and application requirements. [5]

The official downloads and detailed installation instructions are provided by Oracle. [6] Step-by-step installation guides, including for Windows, are available from Informatica and Hevo Data. [7] [3] [8]

Configuration and usage

Connector/ODBC supports multiple configuration approaches:

Technical features

Version history

A detailed official changelog and history is maintained by Oracle. [23]

Practical integration and use cases

MySQL Connector/ODBC is commonly used for:

Practical deployment scenarios, configuration advice, and troubleshooting are available in [third-party technical articles]. [8] [7] [3]

Troubleshooting and maintenance

Comprehensive troubleshooting and debugging guidance, including error code lists and reporting bugs, are part of the official documentation. [20] [21] [24]

See also

References

  1. 1 2 3 "Introduction to MySQL Connector/ODBC". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  2. "MySQL Connector/ODBC History". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  3. 1 2 3 4 "MySQL ODBC Connector: Overview, Features & Installation". Hevo Data. Hevo. Retrieved 2025-07-14.
  4. "Connector/ODBC Platforms". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  5. "Connector/ODBC Release Notes". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  6. "MySQL Connector/ODBC downloads". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  7. 1 2 "Installing MySQL ODBC Driver on Windows". Informatica. Informatica. Retrieved 2025-07-14.
  8. 1 2 3 4 "MySQL Connector/ODBC in Practice: Installation, Configuration, and Integration". pcffm.de. Meroth IT-Service. Retrieved 2025-07-14.
  9. "Data Source Names". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  10. "Connector/ODBC Connection Parameters". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  11. "Configuring a Connector/ODBC DSN on Windows". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  12. "Configuring a Connector/ODBC DSN on macOS". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  13. 1 2 "ODBC Connection Pooling". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  14. 1 2 "Authentication Options". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  15. "Connector/ODBC Examples". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  16. "ODBC Standards Support". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  17. "ODBC Transactions". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  18. "Server-Side Prepared Statements". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  19. "Connector/ODBC Data Types". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  20. 1 2 "Troubleshooting and Debugging". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  21. 1 2 "Connector/ODBC Error Codes". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  22. "Connector/ODBC API Reference". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  23. "Connector/ODBC Version History". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  24. "How to Report Connector/ODBC Problems or Bugs". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.