ODBC error: Lost connection, waiting for communication packet

[Mike J]

Hi,

I have been battling error for a few days now and I am not sure what else to look for. Basically, I am trying to set-up a remote connection to MySQL using MS Access and Excel (Mysql for Excel). MySQL is hosted with siteground.com

When adding DNS using ODBC Administrator, I enter all the information and hit TEST. The window freezes for a bit, but I get a message saying that connection is successful (same for Access and Excel).

Once the connection is added:
- In Access, when try to link the table, Access freezes and get the following message: It says Lost connection to MySQL servier at waiting for initial communication packet, system error: 10060 (#2013)

- In Excel, I get the following error:
Exception message:
Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Exception thrown by:
Utilities.ExecuteNonQuery

Stack trace:
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at MySql.Data.MySqlClient.TimedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.LoadPacket()



Here is the thing, connecting remotely to remotemysql.com using Access works without any issues.I am on Win 7 x64, Office 365 x64 and tried both ODBC 8.0 and 5.3 x64 drivers.