MariaDB Connector/ODBC is a standardized, LGPL licensed database driver using the industry standard Open Database Connectivity (ODBC) API. It supports ODBC Standard 3.5, can be used as a drop-in replacement for MySQL Connector/ODBC, and it supports both Unicode and ANSI modes.

The 1.0 branch of MariaDB Connector/ODBC is Windows-only and the 2.0 branch works on both Windows and Linux.

The most recent stable (GA) release of MariaDB Connector/ODBC is:
MariaDB Connector/ODBC 2.0.13

DateReleaseStatusRelease NotesChangelog
19 Jan 2017MariaDB Connector/ODBC 3.0.0AlphaRelease NotesChangelog
31 Oct 2016MariaDB Connector/ODBC 2.0.13Stable (GA)Release NotesChangelog
15 Sep 2016MariaDB Connector/ODBC 2.0.12Stable (GA)Release NotesChangelog
9 Jun 2016MariaDB Connector/ODBC 2.0.11Stable (GA)Release NotesChangelog
11 Apr 2016MariaDB Connector/ODBC 2.0.10Stable (GA)Release NotesChangelog
16 Nov 2015MariaDB Connector/ODBC 2.0.9BetaRelease NotesChangelog
11 Apr 2016MariaDB Connector/ODBC 1.0.6Stable (GA)Release NotesChangelog
10 Sep 2015MariaDB Connector/ODBC 1.0.5Stable (GA)Release NotesChangelog
29 Jan 2015MariaDB Connector/ODBC 1.0.0Stable (GA)Release NotesChangelog
2 Apr 2014MariaDB ODBC Driver 0.9.1BetaRelease NotesChangelog

Obtaining MariaDB Connector/ODBC

The driver is available for download from https://downloads.mariadb.org/connector-odbc/

You should install both the 32-bit and 64-bit drivers. Otherwise you may get this error message:

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.

Source code

The source code is available on GitHub: https://github.com/MariaDB/mariadb-connector-odbc

Connection parameters

When configuring a DSN you can use the following keywords:

  • DSN: Name of the DSN
  • Driver: The name of the MariaDB ODBC Driver. Must always be {MariaDB ODBC 2.0 Driver}
  • Server: name or IP of the MariaDB database server. Aliases: Servername
  • User: user name for database authentication. Aliases: UID,
  • Password: password for database authentication. Aliases: PWD
  • Database: default database. Aliases: DB
  • Port: TCP/IP Port of the database server
  • Option: For MySQL Connector/ODBC compatibility. Aliases: Options

Example

  SQLWCHAR *ConnStr= L"Driver={MariaDB ODBC 2.0 Driver};Server=localhost;UID=odbc_user;PWD=odbc_pw;DB=odbc_test;Port=3306";

Known bugs and limitations

  • multiple statement execution is not fully supported

Bug reporting

In case you will find a bug, please report it via the Jira bug system for MariaDB products.

License

GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

For licensing questions, see the Licensing FAQ.

Comments

Comments loading...
Loading