About MariaDB Connector/ODBC

You are viewing an old version of this article. View the current version here.

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

DateReleaseStatusRelease 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 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 server
  • Option: 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.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.