MySQL Forge

Resources for the MySQL Community

MyODBC

MySQL Connector/ODBC

Contents 1 Introduction 2 General Feature Support 3 Resources 4 External Links

[edit] Introduction

MySQL Connector/ODBC is the name of MySQL's ODBC driver. It's also called MyODBC. There are currently two series of drivers:

• 3.51 - Current production driver
  • Can be downloaded at MySQL Connector/ODBC 3.51 Downloads
• 5.1 - Branch of 3.51 for new development (Currently Release Candidate)
  • Can be downloaded at MySQL Connector/ODBC 5.1 Downloads
  • Development snapshots can be downloaded at MySQL Product Snapshots
  • Includes the following new features:
    • Unicode support conforming to ODBC specification (SQL*W APIs and SQL_C_WCHAR support)
    • ODBC descriptor support
    • SQLCancel() support (for cancelling a query in another thread)
    • Native Windows setup GUI (for connection information prompting)
    • Replaced the internal library which handles creation and loading of DSN information. (from Connector/ODBC 5.0)
  • For more details and a list of changes per version, see the ChangeLog file in the source distribution.

There was previously a product called MySQL Connector/ODBC 5.0. This was a brand new code-base, but after evaluation, it was determined that the 3.51 code-base was the better choice for new development. MySQL Connector/ODBC 5.0 is no longer under development and no new bug reports are being accepted.

[edit] General Feature Support

The following are supported features that are commonly used:

• Dynamic cursors (must be enabled on the DSN or using the OPTION parameter in a DSN-less connection)
• Positioned updates of cursors (via SQLSetPos() or WHERE CURRENT OF <cursorname> syntax)
• Unicode support via ADO in VB/VBScript/IIS (works out of the box)

Many operating systems are supported through their native driver managers:

• Windows (built-in driver manager)
• Mac OS X (modified iODBC included with operating system)
• UNIX/Linux - tested on many 32-bit and 64-bit platforms including multiple Linux distributions, Solaris, AIX and HP-UX
  • iODBC - using default 4-byte SQLWCHAR
  • unixODBC - using default 2-byte SQLWCHAR

If you have additional requirements from the driver, please feel free to start a discussion in any of the channels mentioned in the MyODBC#Resources section below.

[edit] Resources

• Freenode IRC, channel #mysql or #mysql-dev
• MySQL ODBC list - read/search archives or subscribe at MySQL Lists
• MySQL ODBC forums

[edit] External Links

• MySQL Connector/ODBC 5.1 Released as Beta - (Kaj Arnö blog)
• Re-engineered ODBC 5.1 driver for MySQL - (Kaj Arnö blog)
• MySQL Connector/ODBC documentation - (MySQL Reference Manual)