RE: Mysql server has gone away error

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
settings:
http://dev.mysql.com/doc/refman/5.0/en/myodbc-configuration-connection-param
eters.html
- 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
using ADO?) 

Al McNicoll
Integritec Limited


-----Original Message-----
From: geniekids [mailto:[email protected]] 
Sent: 05 June 2008 06:35
To: [email protected]
Subject: Mysql server has gone away error


Hi
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
QUOTE:
ODBC call failed
[MYSQL][ODBC MYSQL 5.1 Driver][mysqld-5.0.45-community]Mysql server has gone
away (#2006)
UNQUOTE

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)
ratnesh
-- 
View this message in context:
http://www.nabble.com/Mysql-server-has-gone-away-error-tp17662496p17662496.h
tml
Sent from the MySQL - ODBC mailing list archive at Nabble.com.




-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]