Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    11

    Connection lost from mysql remote odbc with MS Access


    0down votefavorite
    Hi I am using MS Access and have used mysql odbc to connect to a remote mysql server database. I have already set ip address on cpanel remote mysql section to allow my ms access database to connect with that. I managed to link to this database from MS Access and linked tables are imported in my ms access database but as soon as I try to open those table from ms access I get message that connection lost. What could be the reason why connection is lost when I try to open remote mysql database table in MS Access. Is this some firewall stopping it .. what could be the solution. If Cpanel has remote mysql then does it not mean that it supports remote access. I want to have a non disconnecting connection with my ms access database and possibly I have a plan to extend it to multiple users and convert this to a single database and multiple users application with each user with a copy of access database. Secondly are there any free remote mysql hosting option or free vps server option. Kindly reply thanks.


  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    If you are unable to get to the point where you can actually see data in your tables you're not establishing the links at all. It's unclear to me but you seem to be saying that your database goes through a linking process but you are never able to see the data even though the tables appear to be linked. How are you attempting to perform the link, are you creating an ODBC connector through control panel > administrative tools > odbc drivers? or are you creating a connection on the fly? I've had issues recently with a DSN free connection that ceased to function even though it appeared to be linking tables correctly.

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

Similar Threads

  1. Replies: 5
    Last Post: 12-16-2015, 02:23 PM
  2. Replies: 3
    Last Post: 04-24-2015, 05:09 AM
  3. How to make a persistent ODBC connection MySQL to Access
    By Yann63 in forum Import/Export Data
    Replies: 4
    Last Post: 01-24-2014, 09:44 AM
  4. Odbc connection mysql 5.1
    By PATRICK in forum Programming
    Replies: 0
    Last Post: 03-07-2013, 05:53 PM
  5. Replies: 3
    Last Post: 01-06-2012, 04:17 PM

Tags for this Thread

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