what odbc driver should I use to access my MariaDB database
I am using Office 365 Home / MSAccess front end code to access my database at InMotion. I downloaded a MySQL ODBC 5.1 Driver and it works but I get intermittent error messages (MySQL server has gone away, Lost connection to MySQL Server during query, etc). I noticed there are also MariaDB ODBC drivers available for download. What driver and version do you recommend for best/cleanest connection?
Hello Musicfortress,
Sorry for the problems with your intermittent connection to the MariaDB using the MySQL ODBC 5.1 driver. I tried to research the issue and did not see any forum posts regarding the driver. My recommendation is that you submit a ticket or call into our live technical support crew. They can help troubleshoot the connection to see what may be causing the issue. You may also try going through the PingPlotter article and running a traceroute to help determine if the issue is related to your network connection.
If you have any further questions or comments, please let us know.
Kindest regards,
Arnel C.