Connect External ODBC Table Not Working

Using YUM I downloaded and installed the connect engine for MariaDB 10.1.25, unixODBC and unixODBC-devel.

I have been able to successfully setup my

odbc.ini

and

odbcinst.ini

and after setting up the LD_LIBRARY_PATH am able to successfully connect to and query an Oracle data source using

isql [dns] [uid] [pwd]

.

The problem comes when I try to issue the create table statement, at that point, I get a message stating that the file libsqora.12.1 can not be found.

So I read through some posts and the MariaDB page

https://mariadb.com/kb/en/mariadb/connect-odbc-table-type-accessing-tables-from-another-dbms/#table-name-case

And realized the problem may have been because I was either using SELinux or that the user running MySQL didn't have the necessary permissions.

I confirmed that SELinux is disabled and identified that the root user is running MySQL, so I updated the root user to have the same LD_LIBARAY_PATH in .bash_profile and then logged in as root using sudo su - root and successfully ran the isql command.

From here I then restarted the MySQL service and attempted to run the CREATE TABLE statement again as below.

create table customer  

ENGINE=CONNECT TABLE_TYPE=ODBC 

tabname='tableName' CONNECTION='DSN=Oracle;UID=xxx;PWD=xxx';

But I still get the same error which is that libsqora.12.1 cannot be found.

I'm struggling to know what to try next or what logs to check to try and find more information on the problem.

In addition, I have run

chmod 777

out of desperation on the folder containing libsqora.12.1 but that hasn't made any difference either.

Hope you can help.