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-tp176 62496p17662496.html
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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

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:geniekids@gmail.com]
Sent: 05 June 2008 06:35
To: myodbc@lists.mysql.com
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-tp176 62496p17662496.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/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Mysql server has gone away error

Thanks Al
Actually i was using ODBC 3.51.x only - but since i was facing the same
problem with that i thought upgrading to 5.x will help.

I also looked into the links that you have provided below - but nothing
seems to be different
I am using a user data asource and i don;t think i am using any ADO (though
possibly i am not sure :-(
I am attaching a screen shot of how i am doing the connection

http://www.nabble.com/file/p17690572/connection%2Bwindow.jpg
connection+window.jpg

thanks for all the help - but really need somebody like you to guide me
though and get this working - a bunch of my faculty (we are a child dev.
org) are waiting for this program to work so that they can enter their
teaching plan into it!!

I am even ok with emailing you the domain name, password etc for the mysql
and and the msaccess file - so that you can try from your local comp.

ratnesh



Al McNicoll wrote:
>
> 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:geniekids@gmail.com]
> Sent: 05 June 2008 06:35
> To: myodbc@lists.mysql.com
> 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-tp176 62496p17662496.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/myodbc?unsub=lists@nabble.com
>
>
>

--
View this message in context: http://www.nabble.com/Mysql-server-has-gone-away-error-tp176 62496p17690572.html
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/myodbc?unsub=gcdmo-myodbc@m.gmane.org