Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Reconnect a remote view to SQL server.
Versions des environnements
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,
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement