when trying to create an ODBC table with the CONNECT engine (in reality a
'link' to a MS SQL Database Table) the command fails with 'Unsupported table
type ODBC':

MariaDB [testdb]> create table MSSQL_CData engine=CONNECT `table_type`='ODBC'
tabname='CData' connection='DSN=MSSQLDB;UID=username;PWD=password' ;
ERROR 1105 (HY000): Unsupported table type ODBC


ldd should show a dependency to unixodbc libs which it doesn't:

mysql-test:~ # ldd /usr/lib64/mysql/plugin/ha_connect.so
        linux-vdso.so.1 (0x00007ffcbc096000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f94c88e1000)
        libz.so.1 => /lib64/libz.so.1 (0x00007f94c86cb000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x00007f94c835f000)
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f94c7fd6000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f94c7cd9000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f94c7ac1000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f94c771e000)
        /lib64/ld-linux-x86-64.so.2 (0x00005651365c7000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f94c751a000)
        liblzma.so.5 => /usr/lib64/liblzma.so.5 (0x00007f94c72f0000)


there has been a similar debian bug report
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=814944

as well as upstream
https://jira.mariadb.org/browse/MDEV-9684

according to the latter the issue should have been fixed as of 10.0.24 which
for Leap 42.2 (as well as Leap42.1, openSuSE 13.2) is not:

mysql-test:~ # rpm -qf /usr/lib64/mysql/plugin/ha_connect.so
mariadb-10.0.29-18.1.x86_64

mysql-test:~ # rpm -qi mariadb-10.0.29-18.1.x86_64
Name        : mariadb
Version     : 10.0.29
Release     : 18.1
Architecture: x86_64
Install Date: Do 11 Mai 2017 15:14:28 CEST