topic Re: MariaDB ODBC connectivity .so file name in Administration and Deployment

MariaDB ODBC connectivity .so file name

ksuman — Fri, 03 Jul 2020 09:55:25 GMT

Hi Tech Experts,

We would like to setup connectivity to MariaDB from SAS using SAS Access,
can any one help us to identify what is the .so file name to make entry on ODBC.ini Driver parameter (Linux),
and configuration steps

Thanks,
Reddy

Re: MariaDB ODBC connectivity .so file name

Nigel_Pain — Fri, 03 Jul 2020 10:25:17 GMT

Take a look in the MariaDB website's KnowledgeBase (I don't seem to be able to create any links here). According to this, you need to add something like this to your odbcinst.ini file:

[MariaDB ODBC 3.0 Driver]
Description = MariaDB Connector/ODBC v.3.0
Driver = /usr/lib64/libmaodbc.so

But the path would depend where you've installed the driver.

Re: MariaDB ODBC connectivity .so file name

ksuman — Fri, 03 Jul 2020 12:41:40 GMT

@Nigel_Pain Thank you,

which RPM has to install on linux to find "libmaodbc.so" file or do have to procure the licese MariaDB driver ? can we connect thogh SAS Access ?

we have below RPM's in Linux server

MariaDB-common-10.3.23-1.el7.centos.x86_64
MariaDB-compat-10.3.23-1.el7.centos.x86_64
MariaDB-client-10.3.23-1.el7.centos.x86_64

Please help

Re: MariaDB ODBC connectivity .so file name

Nigel_Pain — Fri, 03 Jul 2020 13:14:01 GMT

Sorry, I can't help there, never used that sort of Linux. But looking at version numbers on the MariaDB website I don't think it's any of those. I think they're for installing the DB package. But you probably need the MariaDB Connector/ODBC package if you can find it, or download it from their site. Latest version is 3.1.