Jump to content

MySQL Connector/ODBC

From Wikipedia, the free encyclopedia
MySQL Connector/ODBC
Developer(s)Oracle Corporation (originally MySQL AB)
Operating systemMicrosoft Windows, Linux, macOS, Unix-like
PlatformCross-platform
TypeDatabase driver
LicenseGPLv2 with FOSS License Exception
WebsiteMySQL 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]

Overview

[edit]

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

[edit]

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

[edit]

Connector/ODBC supports multiple configuration approaches:

  • System DSNs, user DSNs, and file DSNs are supported on all platforms.[9]
  • DSN-less connections (using full connection strings) are widely used.[10]
  • Configuration for DSNs on Windows and macOS is described in official documentation.[11][12]
  • Connection pooling, authentication options, and example usages are extensively documented.[13][14][15][8]

Technical features

[edit]
  • Compliance with ODBC 3.51 and 3.8 specifications, partial ODBC 4.x support.[16]
  • Unicode and ANSI driver variants for Windows, only Unicode for Unix-like systems.[1]
  • Full support for transactions, savepoints, and rollbacks.[17]
  • Client-side and server-side prepared statements.[18]
  • Native access to MySQL data types, including JSON, BLOB, geometry, BIT.[19]
  • Authentication plugins and SSL/TLS encryption for secure connections.[14]
  • Bulk operations, streaming, connection pooling.[13]
  • Diagnostics, logging, error codes for troubleshooting.[20][21]
  • An API reference is maintained online.[22]

Version history

[edit]

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

  • MyODBC 2.50/2.51: ANSI, MySQL 3.x
  • 3.51: ANSI-only, ODBC 3.51 compliance
  • 5.1–5.3: Unicode/ANSI, ODBC 3.8, 64-bit, DSN file support
  • 8.0+: MySQL 8.0+ support, modern authentication, renewed 32-bit support (from 8.0.35)
  • 9.x: Latest releases (as of July 2025: 9.3.0), MySQL 8.x and 9.x

Practical integration and use cases

[edit]

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

[edit]

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

See also

[edit]

References

[edit]
  1. ^ a b c "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. ^ a b c d "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. ^ a b "Installing MySQL ODBC Driver on Windows". Informatica. Informatica. Retrieved 2025-07-14.
  8. ^ a b c d "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. ^ a b "ODBC Connection Pooling". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  14. ^ a b "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. ^ a b "Troubleshooting and Debugging". MySQL Developer Zone. Oracle Corporation. Retrieved 2025-07-14.
  21. ^ a b "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.
[edit]
Retrieved from "https://en.wikipedia.org/w/index.php?title=MySQL_Connector/ODBC&oldid=1300460813"