The Ultimate Guide to High Availability with MariaDB

About MariaDB Connector/ODBC

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

Obtaining MariaDB Connector/ODBC

The driver is available for download from https://downloads.mariadb.org/connector-odbc/

You may 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 Launchpad: https://code.launchpad.net/mariadb-odbc-driver

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
  • The driver is currently available for Windows platforms only. Support for other platforms is scheduled for version 1.1

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.