Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Connection won't close
Message
From
13/02/2003 13:00:02
Jorge Haro
Independent Consultant
Juarez, Mexico
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00752453
Message ID:
00752797
Views:
16
Yes Terry I'm pretty sure it's open, the problem is not determinig if it's open, since it's pulling data, and the graph goes from 0 connections to 1 connection in performance monitor, the problem is that it doesn't go back to 0 when I close it. Although I'm thinking it's remaining cached or something for performance purposes. The connection even appears as closed in VFP (state = 0) and any attempt to use it generates an error. Thanks for helping though.

>Before you close the ADO session, assure the "State" is 1. You can review the COM in "ADO Query Analyzer" for specifics in the download section. > >>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. >>>
Previous
Reply
Map
View

Click here to load this message in the networking platform