Hi!
I've had the same Problem, bud with remoreviews.
The solution was in the errorhandler, if this error occurs i test if the connection to the Server is still broken and then wait a second and test it again (after some cycles, i present the User a nice Message "Connecton was broken, try to reconnect...".)
If then the server / Connection is back again you have to set each sql Handle idleDisconnect:
asqlhandles(laSqlhndls)
for each m.lnOdbchdbc IN m.laSqlhndls foxobject
sqlIdleDisconnect(m.lnOdbchdbc)
endfor
so the Problems disapear.
To test my solution i simply disconnected the Cable, or switched off the Networkadapter in the System tray.
This also worke's with temporary broken WLAN Connections.
HTH