Configuring MariaDB OCBC connection

 Ensure unixodbc is working fine:

[root@unica12node1 lib]# odbcinst -j

unixODBC 2.3.1

DRIVERS............: /etc/odbcinst.ini

SYSTEM DATA SOURCES: /etc/odbc.ini

FILE DATA SOURCES..: /etc/ODBCDataSources

USER DATA SOURCES..: /root/.odbc.ini

SQLULEN Size.......: 8

SQLLEN Size........: 8

SQLSETPOSIROW Size.: 8

Configure /etc/odbdinst.ini

[MariaDB]

Driver=/opt/cdata/cdata-odbc-driver-for-mariadb/lib/libmariadbodbc.x64.so

Description=ODBC Driver for MariaDB

Driver          = /docker/unica/mariadb/lib/libmaodbc.so

Setup           = /docker/unica/mariadb/lib/libmaodbc.so

Driver64        = /docker/unica/mariadb/lib/libmaodbc.so

Setup64         = /docker/unica/mariadb/lib/libmaodbc.so

FileUsage       = 1

Configure /etc/odbc.ini

[root@unica12node1 lib]# cat /etc/odbc.ini

[CData MariaDB Source]

Driver=/docker/unica/mariadb/lib/libmaodbc.so

User=root

Password=P@ssw0rd

Database=unicadb

Server=192.168.1.162

Port=3306

Check driver is registered:

[root@unica12node1 lib]# odbcinst -q -d

[PostgreSQL]

[MySQL]

[MariaDB]

Test connection:

[root@unica12node1 lib]# isql -v "CData MariaDB Source"

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL>