ODBC --call failed - struggling with this for weeks

[Lior123]

Hi,

I just started working with access and I am getting this error every two queries that I run. What I need to do is close Access and start it again and then I get to run two more queries and it crashes again.

I dont know why this is happening but obviously something it wrong. I Googled it and could not find an answer.

The error message I get is:

ODBC--call failed.
[MySQL][ODBC 5.1 Driver]....-highperf-b13-log]MySQL server has gone away (#2006)

Does anyone know why this is happening and what I can do to fix it?

Please let me know.

Thanks,
- Lior

 

[james_lankford]

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

there's a list of reasons on this page
anything sound possible ?

and also the last post on this page
http://www.nabble.com/Mysql-server-has-gone-away-error-td17662496.html
might offer a solution, but I am no expert on MySQL, DSN and ODBC