Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO Connection won't close
Message
De
12/02/2003 18:35:45
Jorge Haro
Independent Consultant
Juarez, Mexique
 
 
À
12/02/2003 15:26:38
Jorge Haro
Independent Consultant
Juarez, Mexique
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00752453
Message ID:
00752561
Vues:
13
I've been running some further tests and it seems that the connection "disappears" from performance monitor after around one minute. Furthermore, if I create a connection, open it, and then call it's close method, it also keeps showing up in performance monitor, but if I call close again there's an error indicating me that the connection is already closed, which of course figures. Maybe it's just a form of connection "pooling", can anyone confirm or deny this?

>Using VFP 6, SP5, SQL Server 7.0 Developer edition and MDAC 2.7 (ADO), I'm running into this situation with code like the following :
>
>
>thisform.oConnection.Open()
>thisform.RunProcess()
>thisform.oConnection.Close()
>MessageBox("Process finished")
>
>
>The connection remains open until I close the messagebox window.
>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform