FiveTech Software tech support forums

Thank you Rao

"ServerAddress:port"

eg:

Code: Select all  Expand view

190.30.20.20:3306

Hello Rao
how to specify the port with FW_OpenAdoConnection() ?

Maurizio

Code: Select all  Expand view

oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABASE2+","+xUSERID+","+XPASSWORD, .T. )

We can also write like this:

Code: Select all  Expand view

oCn := FW_OpenAdoConnection( { "MSSQL", xSOURCE, xDATABASE2, xUSERID, XPASSWORD }, .T. )

Thank you Rao

... is closed. If the value >= 1 the connection is open and the actual value depends on the current activity. If oCn is closed we can try reconnect by oCn:Open() This is a sample code to check the connection status and try to reconnect. function Check( oCn )   if oCn:State ...

Hello Everyone, Is it possible to determine if FW_OpenAdoConnection is still alive before a FW_OpenRecordSet call and if it is NOT, is there a way to reestablish connection? Here is my sample code establishing connection. oCn := FW_OpenAdoConnection( "MSSQL,"+xSOURCE+","+xDATABAS...

Our FWH maria library initially connects to the server with MYSQL_OPT_RECONNECT option. As many other users advised, time out or sleeping and any such reasons are irrelevant. Even if timed out, any communication with the server ( eg even a simple oCn:Ping() ) will automatically wake up the connectio...

... "lost Connection" is shown and an error message is generated. Mr Rao says " But please keep in mind, you do not need to try to reconnect. All that kind of work, the library has already done. " I just would like to know, the best approach to prevent this error message when ...

... for showing your custom message instead of the library's built in message. Is that okay? But please keep in mind, you do not need to try to reconnect. All that kind of work, the library has already done.

There is not time limit if the internet or network is restored even after an hour it will be automatically reconnected. Even during disconnection, the user can continue to browse, print, export to excel and do everything except editing and writing data to the database. Even ...

Rick,

You are right. Disconnect internet then it runs properly, and even if you reconnect again it continues working.

But with internet connection, it exits on start.

The ResEdit case...

... with WiFi networks, where, thanks to FiveWin for existing, when they have a micro-cut of a few seconds, it freezes for a couple of seconds and reconnect. The problem is that when it tries to reconnect and does not do so in 15 seconds, it gives me a [b] Fatal Error [/ b] where the application ...

... failure, a rowset returns the message: http://maxxtech.com.br/forum/error-rowset.jpg I have already tried to make an attempt to reconnect and this is ok, I just wish that the error message did not appear, how to do it?

... procedure Connection_Test() Local oError, lConectaNovamente := .f. TRY if !M->oServer:Execute( "SET @dummy=0" ) M->oServer:ReConnect() endif CATCH oError lConectaNovamente := .t. END if lConectaNovamente MsgRun("Tentando Reconectar no Banco de Dados...",, {|| Conecta_Banco() ...