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

    Connection issues to MySQL server: waiting for initial communication packet


    Hi,

    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 (siteground.com) says that there are no issues on their end. Click image for larger version. 

Name:	error.png 
Views:	22 
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
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    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
    Location
    UK - Wiltshire
    Posts
    3,001
    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 http://access.mvps.org/access/general/gen0018.htm
    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