O$: ADSL or WiFi timeout

[Franco Maregotto]

Ciao $all
in my application, when MAc or PC goes into sleep mode, or for any reason (too much time sleeping) the connection drops, I detect this with:

Do tsk_StatemObj.$execdirect()
Calculate ErrCode as tsk_StatemObj.$nativeerrorcode
Calculate ErrText as tsk_StatemObj.$nativeerrortext
Calculate ErrNative as tsk_StatemObj.$sqlstate()

If ErrCode=-1&ErrNative=''
-- For sure connection dropped. In other words Mac or PC must establish/refresh a connection to WiFi lan
etc etc
End If

My question is: when this happens both Mac and PC wait about 30 seconds to decide that it's time to stop trying to get a response from the server and give me back ErrCode=-1
How and where could I inspect to reduce this time? Is it a router setting? Or a PGSQLSESS obj setting to be set in $options (how in this case?)

Many thank for any reply

Franco Maregotto
franco at hotelaqua.it