>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
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham