Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Reconnect a remote view to SQL server.
Environment versions
Network:
Windows 2003 Server
Hi aleksey (or anyone else providing me with the answer),
I'm faced with a thorny problem with remote views (or updatable SPT for that matter). In unreliable networks or workstations that fall into hybernate (sleep) mode the ODBC connection of a remote view is dropped. My application can detect that such event is occuring.
I want to recover from such situation when the network is back online again. Currently I have to close every form with remoteviews that are bound to GUI controls. In other forms I can just close and open the views again. It is not an ideal situation, esspecially in cases where users walking arround with their laptop and are hopping from one to another (wireless) access point.
Now VFP offers a solution with offline views which I unfortunately cannot use at the moment (the DBC is build into the executable). Offline views can be brought online again. However, normal remote view cannot.
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 ?
TIA,
Walter,
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only