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.dll,,, or 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, libodbc:

INSTALL SONAME 'ha_connect';
ERROR 1126 (HY000): Can't open shared library '/home/ian/MariaDB_Downloads/10.1.17/lib/plugin/' 
  (errno: 2, 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

See Also


Comments loading...