Hi Claudio,
from MySQL help...
If the mysql client loses connection to the server while sending it a query, it will immediately and automatically try to reconnect once to the server and send the query again. Note that even if it succeeds in reconnecting, as your first connection has ended, all your previous session objects are lost : temporary tables, user and session variables. Therefore, the above behaviour may be dangerous for you, like in this example where the server was shut down and restarted without you knowing it :
see to "4.8.2 mysql, The Command-line Tool"
MartinaJ
>>Use AERROR() function to capture ODBC error info.
>>
>
>this is the message got from aerror/mysql... seems that I really need to restart the connection:
>
>
>[MySQL][ODBC 3.51 Driver][mysqld-4.1.12-Max-log]MySQL server has gone away
>
>
>What do you think?
>
>>>
>>>I do have an app. that was created for remote web access of mysql data..
>>>
>>>it is an ussual logic by:
>>>
>>>1. open the conection to DB
>>>2. start the update/insert user procedures.. During almost all day long..
>>>3. Close the conection
>>>
>>>All working fine, on developing time.. But, on the production, the app. faces the new variable named 'time'..
>>>
>>>It is very common for a given period.. the application starts to return -1 on the insert/update sql's commands...
>>>
>>>So, at this time, for me, the logic stuff.. seems to change the logic to start the conection again on every -1 returned...
>>>
>>>But, before to go to this (a little) unlogic step.. I'd like to read advices here.. Or (who knows) maybe other options on the connections..
>>>
>>>TIA
>>>
>>>BTW, this is my actual try:
>>>
>>>
>>> privStrConexao = "DRIVER=MySQL ODBC 3.51 Driver;" +;
>>> "SERVER=" + this.cServidor_bancodedados + ";" +;
>>> "UID=myuser;" +;
>>> "PWD=mypass;" +;
>>> "DATABASE=mydb;" +;
>>> "WSID=" + Lower(Substr(Sys(0), 1, Atc("#", Sys(0))-1)) + ";" +;
>>> "Port=3306;OPTION=3;" +;
>>> "Trusted_Connection=Yes"
>>> privConexao = 0
>>> i3 = 0
>>> If Type("this.privConexao") = "U"
>>> This.AddProperty("privConexao", .F.)
>>> Endif
>>> This.privConexao = Sqlstringconnect(privStrConexao)
>>>>>>
>>>Claudio
