NetTalk Central

Author Topic: odbc mysql connection sleep  (Read 7208 times)

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
odbc mysql connection sleep
« on: July 31, 2015, 05:34:20 AM »
Hello everyone !.
Every day I have to restart the webserver because it hangs.
This happens when there is no activity for long hours.

An example is when I want to enter a browse. In the first click on the menu does not bring information on the second load data well. But if I want to access from a loguin form hangs.

Use: mysql odbc
Clarion 10 (probmema began to update clarion 8 to 9)
NT 8.51

I leave an attachment example

Any ideas?

thanks

Agustín

[attachment deleted by admin]

astahl

  • Sr. Member
  • ****
  • Posts: 308
    • View Profile
    • Email
Re: odbc mysql connection sleep
« Reply #1 on: July 31, 2015, 05:43:03 AM »
Augustin,

I had the same problem before when someone wanted to login.

I use TableName{PROP:Disconnect}, before I do any accessing of tables or data in the loginform.

Depending on how your login is setup, but I have mine in "Validate Update/END" routine.

Ashley

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: odbc mysql connection sleep
« Reply #2 on: August 01, 2015, 04:47:35 AM »
I'll try and I commented

long time I'm done with this problem

thank you very much !!!

Agustín

astahl

  • Sr. Member
  • ****
  • Posts: 308
    • View Profile
    • Email
Re: odbc mysql connection sleep
« Reply #3 on: August 03, 2015, 03:04:00 AM »
Your Welcome Augistin!


Ashley

agustinh2000

  • Jr. Member
  • **
  • Posts: 86
    • View Profile
    • Email
Re: odbc mysql connection sleep
« Reply #4 on: August 12, 2015, 06:46:14 AM »
attached a message when unclicked "Suppress Error Messages" in the webserver (not if there is the problem)
I still have the problem

Thank you
Agustín

[attachment deleted by admin]

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11251
    • View Profile
Re: odbc mysql connection sleep
« Reply #5 on: August 12, 2015, 10:03:13 PM »
you should have "suppress error messages" ticked on for a NetTalk server.

cheers
Bruce