NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: agustinh2000 on July 31, 2015, 05:34:20 AM

Title: odbc mysql connection sleep
Post by: agustinh2000 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]

Title: Re: odbc mysql connection sleep
Post by: astahl 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

Title: Re: odbc mysql connection sleep
Post by: agustinh2000 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

Title: Re: odbc mysql connection sleep
Post by: astahl on August 03, 2015, 03:04:00 AM

Your Welcome Augistin!


Ashley

Title: Re: odbc mysql connection sleep
Post by: agustinh2000 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]

Title: Re: odbc mysql connection sleep
Post by: Bruce on August 12, 2015, 10:03:13 PM

you should have "suppress error messages" ticked on for a NetTalk server.

cheers
Bruce