While using MS ACCESS to connect to MySQL database through MyOdbc, I constantly got the following error: 'server has gone away error #2006'.
After searching the MySql site with no success, I finally find the solution at: SiteGround Forum posted by hwj.
Basically, when create DSN in Windows using ODBC configuration tool, you need to enable the option auto-reconnect immediately before you click OK to exit. According to hwj, if you did not do it while you creating the DSN, you will have to start over.
This works for me!
Hopefully, with this link, it will promote that article in Google search.