Mysql server disconnection

Got Mysql server has gone away error in VB app idle for few seconds

Page 1 of 1

1 Replies - 3360 Views - Last Post: 23 March 2010 - 06:35 AM Rate Topic: -----

#1 deepa_ubdt  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 23-March 10

Mysql server disconnection

Posted 23 March 2010 - 02:37 AM

Hi All,
I have working in VB6.0 and using mysql as backend.In the application connection to mysql server is established during the start of application and connection kept open till the user logout. Able to connect through the application do a query some instance am getting error as

Run-time error '-2147467259 (80004005)':
[MYSQL][ODBC 5.1 Driver][mysqld-5.1.31-1ubuntu2]MYSQL server has gone away


I checked in server connection time out. it is set as 8 hour.Also am able to access through the mysql prompt.

PLEASE HELP ME RESOLVE.

Thankz in advance,
Deepa

Is This A Good Question/Topic? 0
  • +

Replies To: Mysql server disconnection

#2 vb5prgrmr  Icon User is offline

  • D.I.C Lover

Reputation: 109
  • View blog
  • Posts: 1,016
  • Joined: 21-March 09

Re: Mysql server disconnection

Posted 23 March 2010 - 06:35 AM

Never keep a connection to a service open... Open it, use it, close it, and if you have to keep it open, then test it before you try to use it... See ADO tutorial for more info...



Good Luck
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1