From Fedora Project Wiki

m (typo fix)
(Add a config file example)
Line 26: Line 26:
     /etc/odbcinst.ini - general info about the connectors libraries etc.
     /etc/odbcinst.ini - general info about the connectors libraries etc.
     /etc/odbc.ini - specific connectors settings
     /etc/odbc.ini - specific connectors settings
The basic config is already shipped by unixODBC package
The basic "/etc/odbcinst.ini" config is already shipped by unixODBC package
 
/etc/odbc.ini config file example:
    [mariadb-connector-odbc]
    Driver=MariaDB


== Usage ==
== Usage ==

Revision as of 13:46, 3 August 2018

Article about mariadb-connector-odbc package

Connector releases

mariadb-connector-odbc 3.0 - current (F27, F28, Rawhide)

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