Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reconnect a remote view to SQL server.
Message
 
 
To
04/07/2006 04:08:31
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01133536
Message ID:
01133671
Views:
40
Walter,

Why not just rebuffer the data into a native VFP cursor?
USE TheView in 0 alias RemoteViewTemp
select * from RemoteViewTemp into cursor TheView readwrite
use in RemoteViewTemp
>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.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform