The Ultimate Guide to High Availability with MariaDB

Access + MariaDB connector problem

Hi everyone,

I have an issue while executing a query with an ORDER BY on a table linked through a MariaDB ODBC connector to a MS ACCESS 2013 database.

I use the 1.0.5 version of MariaDB ODBC connector and the 10.1.1 version of MariaDB (I don’t want to use a MySQL ODBC connector).

If I try only with a SELECT * it works but from the moment I use the ORDER BY Access freezes for a while and then stops running. The UPDATE queries work fine.

Any help would be much appreciated,

Aurélien MESQUITA.

Answer Answered by Lawrin Novitsky in this comment.

Hello Aurélien, I could recreate your problem with 1.0.5, but it works fine with latest repository version. Looks like there was a bug in the connector, but it has been fixed. You can either wait for new official release, or build connector library from the source from our repository on github. Well, actully you can try this https://jira.mariadb.org/secure/attachment/41512/maodbc.dll - I posted it recently for similar purpose. Lawrin Novitsky

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.