Hi aleksey,

note that I'm on VFP8SP1, but in a test I already tried that. Sometimes success, sometimes it just does not work: The view won't reconnect.

Walter,


>>I was wondering if there is a possibility to get the broken remote view online again. I was looking for using ODBC api's to get the ODBC connection up and running again. Since this is already possible with offline views, there must be a way of getting this done.
>>
>>Can you (or anyone else) push me into the right direction?
>>Can you see a way out of it, or should I start programming a strategy closing and reopening whole forms ?
>>
>
>Hi Walter,
>
>There is a SQLIDLEDISCONNECT() function in VFP9. Try to disconnect "broken" connection using this function, VFP will reconnect automatically at the next attempt to use that connection.
>
>Thanks,
>Aleksey.