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 is the current stable release series.

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

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.