>I was thinking of writing to the system event log inside of the Dispose method of your provider class. To do it you will have to override the Dispose method in the class definition. The date & time is already part of the log, so anything that can identify the individual instance of your class and also connection.State is sufficient for the log entry. Then you can see exactly when the objects that are connected to the database are destroyed. Maybe there is a correlation between objects remaining open and the errors that you are seeing.
>
>This idea comes from working with SQL Server, so it may not be applicable to VFP.
Ok, thanks