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.

Connector/ODBC 2.0 is the current stable release series, 3.0 is the new development release series.

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

DateReleaseStatusRelease NotesChangelog
01 Aug 2017MariaDB Connector/ODBC 3.0.1BetaRelease NotesChangelog
19 Jan 2017MariaDB Connector/ODBC 3.0.0AlphaRelease NotesChangelog
23 May 2017MariaDB Connector/ODBC 2.0.15Stable (GA)Release NotesChangelog
7 Apr 2017MariaDB Connector/ODBC 2.0.14Stable (GA)Release 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

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:

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. Here are used bits meaning:
    • 0(1) - Currently is not used
    • 1(2) - Tells connector to return the number of matched rows instead of number of changed rows
    • 4(16) - See NO_PROMPT
    • 5(32) - Forces use of dynamic cursor
    • 6(64) - Forbids the use of database.tablename.column syntax
    • 11(2048) - Tells connector to use compression protocol
    • 13(8192) - See NAMEDPIPE
    • 22(4194304) - See AUTO_RECONNECT
    • 26(67108864) - Allows to send multiple statements in one query
  • NAMEDPIPE: boolean value(non-zero value is treated as TRUE) determining whether Server is treated as a named pipe name, or as domain name/IP address. Using of NAMEDPIPE is equivalent of setting/resetting of 13th bit(counting from 0, 8192) OPTIONS bit. It has effect on Windows only.
  • TCPIP: has reverse meaning with NAMEDPIPE. i.e. setting TCPIP=0 effectively means NamedPipe=1. This keyword is also Windows specific.
  • SOCKET: full socket name, if it is specified, server name is disregarded. It has effect on Linux only.
  • INITSTMT: SQL command(s) to be run at connection time
  • CONN_TIMEOUT : connect timeout in seconds
  • AUTO_RECONNECT: enabling/disabling automatic reconnect, the same as setting/resetting 22th(4194304) OPTIONS bit
  • NO_PROMPT: suppresses prompt dialog display at the connection time. This has the same meaning as setting/resetting bit #4(16) of the OPTIONS
  • CHARSET: connection character set. Connector assumes that all incoming string data is encoded in this character set, and uses it if recoding to/from Unicode(utf16) encoding is required.
  • PLUGIN_DIR: directory where to look for (Connector/C) plugins.


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.


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 loading...