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
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.
Al McNicoll wrote:
> Dear Ratnesh,
> I develop using Access / MyODBC / MySQL 5.x on a daily basis, and I have
> 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
> 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
> my desktop. I am using ODBC 5.1 to connect the access frontend to the
> 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
> 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 Nabble.com.
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?unsub=1
View this message in context:
Sent from the MySQL - ODBC mailing list archive at Nabble.com.