>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

Hi Dennis,

Try to set FetchSize=-1 for your CA subclass.

Thanks,
Aleksey.

Thanks,