Hi

I am having some trouble with an ADO Command object.

I am using a class with command and connection objects as member variables.

The command and connection objects are initialised with the class instance.

Method calls on my object use the command object to run a stored procedure on a SQL2000 db. The command is executed asynchronously and an event handler is in place on the connection object to handle the ExecuteComplete callback.

Every 4 or 5 calls results in the 'Connection cannot be used it is either closed or invalid...' error. The ActiveConnection property of the command object is now Nothing.

This is not done anywhere in the code and my object does not terminate throughout this application.

I am tearing my hair out trying to solve this.. Does anyone have any ideas..?