From Fedora Project Wiki

Revision as of 12:28, 21 June 2019 by Mschorm (talk | contribs) (Update after F28 EOL)

Article about mariadb-connector-odbc package

Connector releases

mariadb-connector-odbc 3.0 - current ( F27, F28, F29, F30 )
mariadb-connector-odbc 3.1 - current ( >=Rawhide (F31) )

In Fedora<=26 the connector does not work. It is built on top of mariadb-connector-c 3.0, which does not exist in F<=26

Perequisites

Needed:

  • mariadb-connector-odbc
  • mariadb-server
  • unixODBC

Can be used instead:

  • community-mysql-server
  • mysql-connector-odbc

Setup

Running MariaDB server

   systemctl start mariadb

unixODBC

   /etc/odbcinst.ini - general info about the connectors libraries etc.
   /etc/odbc.ini - specific connectors settings

The basic "/etc/odbcinst.ini" config is already shipped by unixODBC package

/etc/odbc.ini config file example:

   [mariadb-connector-odbc]
   Driver=MariaDB

Usage

Interactive mode:

   isql -v mariadb-connector-odbc

Non-interactive mode

   echo "show databases" | isql -v mariadb-connector-odbc -b

Notes

MariaDB ODBC connector does not have setup driver yet.

Upstream infromation