Hosting Plans    Support    Community    Status    Contact Us    Client Login
    Join our Community      Check your private messages       Profile       Search       FAQ       Memberlist       Log in

ODBC and MySQL gone away

  
Post new topic   Reply to topic    NetHosted Community Index -> FTP/SQL Support
colbec Reply with quote
 NetHosted Customer

 

 Joined: 08 Sep 2006
 Posts: 59
 Location: Desert Lake, Ontario
PostPosted: Mon Nov 13, 2006 2:37 pm    Post subject: ODBC and MySQL gone away
 
I'm using Access 97 and an ODBC connection to view the data in my database. While I am merrily querying away after a short time I get a message error 2006 'mysql server has gone away'. I re-start my frontend and everything is fine again. Nuisance.

I guess there is a timeout in effect somewhere - I have found a setting in the Access options for an ODBC refresh interval but I don't know if my setting makes any difference.

Anybody seen this and has an idea what is going on and what the correct action on my part is?
Back to top
View user's profile Send private message Visit poster's website
NetHosted - Andrew Reply with quote
 NetHosted Staff

 

 Joined: 22 Mar 2004
 Posts: 5625
 
PostPosted: Mon Nov 13, 2006 3:22 pm    Post subject:
 
These are the relevant settings the MySQL server has:

interactive_timeout=100
wait_timeout=100
connect_timeout=10

Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think  of NetHosted!
Back to top
View user's profile Send private message
Post new topic   Reply to topic    NetHosted Community Index -> FTP/SQL Support
Page 1 of 1

User Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum

 
Jump to: