I have a subclassed cursoradapter using ADO. I create it the object and it works. However, any successive creations of this cursoradpater class, on the same table or a different one, returns an error when you do a .cursorfill():

ADODB.RECORDSET: The connection cannot be used to perform this operation. It is either closed or invalid in this context.

CLEAR ALL clears this condition. Releasing the object variable for the first cursoradapter does not. I am using SQL Server.

The condition occurs whether or not a .cursorfill() is done with the first object.

Has anyone run into anything like this before and make suggestions as to a solution?

Thanks,

Dennis