About MariaDB Connector/ODBC
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 3.1.20
Date | Release | Status | Release Notes | Changelog |
---|---|---|---|---|
11 Apr 2016 | MariaDB Connector/ODBC 2.0.10 | Stable (GA) | Release Notes | Changelog |
16 Nov 2015 | MariaDB Connector/ODBC 2.0.9 | Beta | Release Notes | Changelog |
11 Apr 2016 | MariaDB Connector/ODBC 1.0.6 | Stable (GA) | Release Notes | Changelog |
10 Sep 2015 | MariaDB Connector/ODBC 1.0.5 | Stable (GA) | Release Notes | Changelog |
29 Jan 2015 | MariaDB Connector/ODBC 1.0.0 | Stable (GA) | Release Notes | Changelog |
2 Apr 2014 | MariaDB ODBC Driver 0.9.1 | Beta | Release Notes | Changelog |
Contents
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 DSNDriver
: The name of the MariaDB ODBC Driver. Must be always{MariaDB ODBC 1.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 serverOption
: For MySQL Connector/ODBC compatibility. Aliases:Options
Example
SQLWCHAR *ConnStr= L"Driver={MariaDB ODBC 1.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.