Solved: Re: ODBC connection to MariaDB - Page 2 - Qlik Community

venelin_rs · ‎2016-10-04

Hi everybody,

I can not establish ODBC connection to MariaDB.

I use next driver: mariadb-connector-odbc-2.0.12-win64 . But I also tried with mysql-connector-odbc-5.3.6-winx64 and previous version of MariaDB driver: mariadb-connector-odbc-1.0.6-win64.

Please help me if someone already fixed the same issue.

Regards,

Venelin

rohitk1609 · ‎2016-10-07

Hi ,

You mean to say you can access all the tables ?

venelin_rs · ‎2016-10-07

Hi,

Yes, I have access to all tables, but I can't extract all tables. I don't know what is the reason, but when I changed to MySQLODBC driver, everything starts to work fine.

rohitk1609 · ‎2016-10-08

Hi

The point here is, if you can specify which type of tables you can't access so I can help . Might happen , you are trying to load those table which are schemas . Again not sure until I don't know which type of tables you can access and which not . Apologies .

venelin_rs · ‎2016-10-08

Thank you for the help Rohit, but fot this case I can not give you specify information about tables.

Now we are working with MySQL ODBC driver and everything is fine. In the future we will see for changing the driver.

rohitk1609 · ‎2016-10-09

Hi Venelin,

This is a good news that your work has been started , Anyhow. In future if please let me know if I can help you.