From Fedora Project Wiki

m (Added link to the upstream information)
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:


== Connector releases ==
== Connector releases ==
<br />'''mariadb-connector-odbc 3.0 - current (F27, F28, Rawhide)'''<br />
 
mariadb-connector-odbc 3.0 - until Fedora 28 ( also available in F29 & F30 base ) <br />
'''mariadb-connector-odbc 3.1''' - current '''( F29 - Rawhide )'''<br />


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
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
Line 8: Line 10:
== Perequisites ==
== Perequisites ==


<br />
'''Needed:'''
'''Needed:'''
* mariadb-connector-odbc
* mariadb-connector-odbc
* mariadb-server
* mariadb-server
* unixODBC
* unixODBC
<br />
 
'''Can be used instead:'''
'''Can be used instead:'''
* community-mysql-server
* community-mysql-server
Line 24: Line 25:


'''unixODBC'''
'''unixODBC'''
     /etc/odbcinst.ini - genral 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 ==
Line 39: Line 44:
MariaDB ODBC connector does not have setup driver yet.
MariaDB ODBC connector does not have setup driver yet.


[https://mariadb.com/kb/en/library/about-mariadb-connector-odbc/ Upstream infromation]
[https://mariadb.com/kb/en/library/mariadb-connector-odbc/ Upstream infromation]





Latest revision as of 14:05, 22 August 2019

Article about mariadb-connector-odbc package

Connector releases

mariadb-connector-odbc 3.0 - until Fedora 28 ( also available in F29 & F30 base )
mariadb-connector-odbc 3.1 - current ( F29 - 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