Share to: share facebook share twitter share wa share telegram print page

MySQL Connector/ODBC

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

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:

  • 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

  • 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

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

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. ^ 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.
Index: pl ar de en es fr it arz nl ja pt ceb sv uk vi war zh ru af ast az bg zh-min-nan bn be ca cs cy da et el eo eu fa gl ko hi hr id he ka la lv lt hu mk ms min no nn ce uz kk ro simple sk sl sr sh fi ta tt th tg azb tr ur zh-yue hy my ace als am an hyw ban bjn map-bms ba be-tarask bcl bpy bar bs br cv nv eml hif fo fy ga gd gu hak ha hsb io ig ilo ia ie os is jv kn ht ku ckb ky mrj lb lij li lmo mai mg ml zh-classical mr xmf mzn cdo mn nap new ne frr oc mhr or as pa pnb ps pms nds crh qu sa sah sco sq scn si sd szl su sw tl shn te bug vec vo wa wuu yi yo diq bat-smg zu lad kbd ang smn ab roa-rup frp arc gn av ay bh bi bo bxr cbk-zam co za dag ary se pdc dv dsb myv ext fur gv gag inh ki glk gan guw xal haw rw kbp pam csb kw km kv koi kg gom ks gcr lo lbe ltg lez nia ln jbo lg mt mi tw mwl mdf mnw nqo fj nah na nds-nl nrm nov om pi pag pap pfl pcd krc kaa ksh rm rue sm sat sc trv stq nso sn cu so srn kab roa-tara tet tpi to chr tum tk tyv udm ug vep fiu-vro vls wo xh zea ty ak bm ch ny ee ff got iu ik kl mad cr pih ami pwn pnt dz rmy rn sg st tn ss ti din chy ts kcg ve
Prefix: a b c d e f g h i j k l m n o p q r s t u v w x y z 0 1 2 3 4 5 6 7 8 9

Portal di Ensiklopedia Dunia

Portal : Agama
Agama
Portal : Bahasa
Bahasa
Portal : Biografi
Biografi
Portal : Budaya
Budaya
Portal : Ekonomi
Ekonomi
Portal : Elektronika
Elektronika
Portal : Film
Film
Portal : Filsafat
Filsafat
Portal : Geografi
Geografi
Portal : Indonesia
Indonesia
Portal : Ilmu
Ilmu
Portal : Lingkungan
Lingkungan
Portal : Masyarakat
Masyarakat
Portal : Matematika
Matematika
Portal : Militer
Militer
Portal : Mitologi
Mitologi
Portal : Musik
Musik
Portal : Olahraga
Olahraga
Portal : Pendidikan
Pendidikan
Portal : Politik
Politik
Portal : Sastra
Sastra
Portal : Sejarah
Sejarah
Portal : Seni
Seni
Portal : Teknologi
Teknologi
Kembali kehalaman sebelumnya