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.
Connector/ODBC 3.0 and 2.0 are current stable release series.
The most recent Stable (GA) release of MariaDB Connector/ODBC is:
MariaDB Connector/ODBC 3.2.3
Date | Release | Status | Release Notes | Changelog |
---|---|---|---|---|
01 Aug 2017 | MariaDB Connector/ODBC 3.0.1 | Beta | Release Notes | Changelog |
19 Jan 2017 | MariaDB Connector/ODBC 3.0.0 | Alpha | Release Notes | Changelog |
23 May 2017 | MariaDB Connector/ODBC 2.0.15 | Stable (GA) | Release Notes | Changelog |
7 Apr 2017 | MariaDB Connector/ODBC 2.0.14 | Stable (GA) | Release Notes | Changelog |
31 Oct 2016 | MariaDB Connector/ODBC 2.0.13 | Stable (GA) | Release Notes | Changelog |
15 Sep 2016 | MariaDB Connector/ODBC 2.0.12 | Stable (GA) | Release Notes | Changelog |
9 Jun 2016 | MariaDB Connector/ODBC 2.0.11 | Stable (GA) | 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 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 serverOption
: 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 whetherServer
is treated as a named pipe name, or as domain name/IP address. Using ofNAMEDPIPE
is equivalent of setting/resetting of 13th bit(counting from 0, 8192)OPTIONS
bit. It has effect on Windows only.TCPIP
: has reverse meaning withNAMEDPIPE
. 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 timeCONN_TIMEOUT
: connect timeout in secondsAUTO_RECONNECT
: enabling/disabling automatic reconnect, the same as setting/resetting 22th(4194304)OPTIONS
bitNO_PROMPT
: suppresses prompt dialog display at the connection time. This has the same meaning as setting/resetting bit #4(16) of theOPTIONS
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.
Following options available in 3.0 connectors only
SSLKEY
: the name of a TLS key for a secure connectionSSLCERT
: the name of a TLS certificate for a secure connectionSSLCA
: the name of a file which contains one or more trusted TLS CAsSSLCAPATH
: the path which contains trusted CAsSSLCIPHER
: a list of cipher suites for TLS encryptionSSLVERIFY
: Enable (or disable) the verification of the hostname against common name (CN) of the servers host certificateSSLCRL
: a file with certificate revocation listSSLCRLPATH
: a directory with contains files with certificate revocation lists
Example
SQLWCHAR *ConnStr= L"Driver={MariaDB ODBC 3.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.