Disappearing connections..

[adam999]

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..?

[swatty]

There has to be a place in code where you close the connection or sets the activeconnection of the command to nothing.


If not the only option i see that the connection is closed because it was interupted over the network ?

[adam999]

Sorry swatty

The connection object held in my object still has a valid connection, its state is ok and its errors collection is empty.

And nowhere in the code is the command object altered aside from setting different values into the parameters until the program is ended.

Thanks for your thoughts though.