Results 1 to 3 of 3
  1. #1
    jcmaad is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2019

    Connection issues to MySQL server: waiting for initial communication packet


    I am having a weird error trying to connect a a remote MySQL server. Here is what I do:
    1. I go to External Data tab and select MySQL source, and add a new Machine Data Source.
    2. I enter all the data in the required fields and hit TEST. (when I select the dropdown for select a table, I get a list of tables within that table)
    3. Access completely freezes for 1-2 minutes and then I get a CONNECTION SUCCESSFUL message.
    4. Once added to the list sources, I select it and then Access freezes again.
    5. A few minutes go by, and get the following error: Lost connection to MySql server at 'waiting for initial communication packet', system error: 10060 (#2013)

    I tried another free sql server and it worked, I can edit the table within Access. My hoster ( says that there are no issues on their end. Click image for larger version. 

Name:	error.png 
Views:	21 
Size:	8.8 KB 
ID:	40057
    I am using Win7 x64 and Office Pro x64. I tried OBDC connector both 5.3 and 8.0. I tried disabling the firewall as well.

    Any ideas what can wrong?

  2. #2
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    As you have made a connection earlier, I presume the user account you use has the necessary rights for remote access, so I I think you get a time-out error there.

  3. #3
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    UK - Wiltshire
    It's timing out due to being over an external WAN I'm guessing?
    Access doesn't enjoy the connectivity over a WAN, see if you can increase the time outs, and make sure you connected directly to your network, not wirelessly.
    DLookup Syntax and others
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-25-2018, 04:15 PM
  2. MySQL server database connection for multiple computers
    By breckjensen in forum Programming
    Replies: 1
    Last Post: 10-20-2017, 08:35 AM
  3. Replies: 5
    Last Post: 12-16-2015, 02:23 PM
  4. Replies: 3
    Last Post: 07-18-2013, 04:08 PM
  5. Odbc connection mysql 5.1
    By PATRICK in forum Programming
    Replies: 0
    Last Post: 03-07-2013, 05:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums