MariaDB starting with 10.0
The CONNECT engine was introduced in MariaDB 10.0.
The CONNECT storage engine is enabled like any other plugin, for instance using the INSTALL SONAME command:
INSTALL SONAME 'ha_connect.[so|dll]';
For the INSTALL command to work, the libraries (
ha_connect.so.0.0.0) must be placed in the standard
MariaDB plugin directory, which is automatically done when using the standard install commands.
In some environments, you may get an error about a missing library,
INSTALL SONAME 'ha_connect'; ERROR 1126 (HY000): Can't open shared library '/home/ian/MariaDB_Downloads/10.1.17/lib/plugin/ha_connect.so' (errno: 2, libodbc.so.1: cannot open shared object file: No such file or directory)
In this case, just install the missing library, for example:
sudo apt-get install libodbc1