I develop using Access / MyODBC / MySQL 5.x on a daily basis, and I have to
admit that I've found that MyODBC 5 has been less reliable than 3.51.x -
maybe try installing 3.51.x as well (they can co-exist peacefully) and see
if you have fewer issues with that...
Otherwise, I recommend the following:
- Check in the documentation that you're using the right connection
- Look on the MySQL / Access forum: http://forums.mysql.com/list.php?65
- Post back to this list, explaining how you're connecting to the server
(are you using a System Data Source, a User Data Source - are you connecting
From: geniekids [mailto:geniekids@stripped]
Sent: 05 June 2008 06:35
Subject: Mysql server has gone away error
I have a mysql database on my web server and an MS Access (2002) frontend on
my desktop. I am using ODBC 5.1 to connect the access frontend to the mysql
database. However i keep getting this error almost every few minutes
ODBC call failed
[MYSQL][ODBC MYSQL 5.1 Driver][mysqld-5.0.45-community]Mysql server has gone
Once this error comes i need to close the ms access and open it again - it
works for few minutes and then the same error.
Any help will be really appreciated.
(i am quite a newbie to mysql and odbc)
View this message in context:
Sent from the MySQL - ODBC mailing list archive at Nabble.com.