MySQL Connector/ODBC

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
MySQL Connector/ODBC
DeveloperOracle Corporation (originally MySQL AB)
Repository
  • {{URL|example.com|optional display text}}Lua error in Module:EditAtWikidata at line 29: attempt to index field 'wikibase' (a nil value).
Engine
    Lua error in Module:EditAtWikidata at line 29: attempt to index field 'wikibase' (a nil value).
    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 | edit source]

    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 | edit source]

    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 | edit source]

    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 | edit source]
    • 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 | edit source]

    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 | edit source]

    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 | edit source]

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

    See also

    [edit | edit source]

    References

    [edit | edit source]
    1. ^ a b c Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    2. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    3. ^ a b c d Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    4. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    5. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    6. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    7. ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    8. ^ a b c d Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    9. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    10. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    11. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    12. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    13. ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    14. ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    15. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    16. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    17. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    18. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    19. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    20. ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    21. ^ a b Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    22. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    23. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    24. ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
    [edit | edit source]
    Retrieved from "http://70.231.62.181/index.php?title=MySQL_Connector/ODBC&oldid=7565223"