The summary:
How do I re-connect to the server when my connection is sleeping?
I created a connection to the server when I created my Analysis using external files.
when I run the program it works but if I do not access the data within 15 second I get the error. According to the ISP they kill sleeping connections after15 seconds but said that the DB should automatically re-connect when the next query is executed.
this makes sense to me but it is not re-connecting. The prorgam is aborted.
PC Soft Free Technical support said ...
This is a MySQL server problem. I suggest you to search for "mysql error 20123" with Google. You will find a lot of information about the error and how to get rid of it.
This is not a WinDev problem.
--------------------------------------------
I do not think this is true????
how do I re-connect to the server after my sleeping connection is killed?
More details :
---------------------------------------------------------------------------------------------------
I am developing a back office application which accesses a MYSQL database which is used for my website.I created tehe connection to the DB when I set up the Analysis.
I am constantly getting the following error :
Request Summary (10 words maximum):
Lost connection to MySQL server during query
Request Details:
Error at line 1 of Click BTN_View process.
HReadSeekFirst function called.
native MySQL access error.
Error Number = 22
Error returned by <xx.xx.xxx.xx> database:
Error Number = <2013>.
Error Message:
Lost connection to MySQL server during query
----------------------------------------------------------------------------------------------
I contacted PC Soft and received the following response ...
This is a MySQL server problem. I suggest you to search for "mysql error 20123" with Google. You will find a lot of information about the error and how to get rid of it.
This is not a WinDev problem.
----------------------------------------------------------------------------------------------
This is the response from my ISP ...
The server will kill off any queries or sleeping connections that last over 15 seconds. The sleeping connections being killed off is not generally an issue because it will just re-connect when needed. Are you having any actual problems with the site?
The sleeping connections that are killed off should just reconnect automatically. You should not have to manually code in the database connection string again. Are you have issues with the back office application currently?
-----------------------------------------------------------------------------------------------
This makes sense because if I am not constantly hitting the server the connection is sleeping and I loose the connection ....
How do I re-connect?