>I haven't read all of this thread so I don't know if this has been brought up already. It sounds like some of the objects within your data provider are hanging around a lot longer than you expect. I mean, while the connection objects might be waiting around for garbage collection another object may pick up the faux-closed connection. I have seen SQL Server hold a connection until the garbage collector disposes the object.
>Perhaps temporarily adding an event log entry in the Disposing method will help to isolate the problem.
I am using VFP as the backend. Is there a way to enable an event log for that? Also, based on this, I am not sure exactly what I would have to do to verify for that.