Forum Discussion

jasmeenkaur27's avatar
jasmeenkaur27
Contributor
7 years ago

ADO Recorset not working

Hi,   When I execute simple query as select * from table name it works but on executing a complex query like below an error is thrown "Operation is not allowed when the object is closed."   var I...
cunderw's avatar
cunderw
Community Hero
7 years ago

This type of error usually indicates your connection has closed, my guess is it has timed out executing such a complex query.

 

Try setting the property before you open the connection:

 

Conn.CommandTimeout = 0;