Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Instant Connection Break ?
Message
De
21/02/2006 10:19:16
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Instant Connection Break ?
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01097737
Message ID:
01097737
Vues:
51
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform