List:MySQL ODBC« Previous MessageNext Message »
From:Al McNicoll Date:June 5 2008 9:18am
Subject:RE: Mysql server has gone away error
View as plain text  
Dear Ratnesh,

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:
- 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
using ADO?) 

Al McNicoll
Integritec Limited

-----Original Message-----
From: geniekids [mailto:geniekids@stripped] 
Sent: 05 June 2008 06:35
To: myodbc@stripped
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
away (#2006)

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

Mysql server has gone away errorgeniekids5 Jun
  • RE: Mysql server has gone away errorAl McNicoll5 Jun
    • RE: Mysql server has gone away errorgeniekids6 Jun