MySQL Forums
Forum List  »  Connector/ODBC

How to make a persistent ODBC MySQL - Access connetion
Posted by: Yves Robeyst
Date: January 17, 2014 10:40AM

Hello

I have connected a MySQL database on a webserver to my Access 2013 database.
using following parameters

[ODBC]
DRIVER=MySQL ODBC 5.2 Unicode Driver
Server=
Port=
User=
Password=
Database=


Connection can be made, but is lost after a few seconds.
In the Access application a screen is used to consult/adapt the MySQL database data in Access. Following occurs : open the screen - no problem connection is made. But after a few seconds system mentions "ODBC - call failed. Lost connection to MySQL server during query (#2013)".

How can I solve this problem and make the ODBC connection persistent?

Thank you in advance.

Options: ReplyQuote


Subject
Written By
Posted
How to make a persistent ODBC MySQL - Access connetion
January 17, 2014 10:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.