Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Instant Connection Break ?
Message
From
21/02/2006 10:19:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Instant Connection Break ?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01097737
Message ID:
01097737
Views:
50
I've noticed when using Access, if I need to "kill" a running query all I need to do is press the + keys and the query stops almost instantly. However, when I need to kill a VFP remote connection view/query, it sometimes takes forever for VFP to release the query. I have ESC set ON so that's not the problem. In both examples, Accesss vs. VFP, both are connected to the same MS SQL back-end. It appears that Access is much more efficient in communicating with SQL to release the connection than VFP. Am I missing something? Has anyone written a PRG or utility that caused a remote view connection to "die" instantly when requested?

Thanks,
Robert Wright
Next
Reply
Map
View

Click here to load this message in the networking platform