Closing ADO resordset and database connection objects

[steve1]

Hi,

Do I need to close my ADO resordset and database connection objects on my ASP pages? If I have to, where & when is the best to close them?



Steve

[anandham]

Hi Steve,
Obviously we should close the ADO recordset & connection string..
i we keep opening the connections then it will always be in open condition only & affects the other connections. Let say there is an application which is use by 20,000 persons. each person will open his connection & when they not close the connection then there is a huge traffic in the ADO application which will eventually lead to damage to the whole system..
so it's a must to close the connections. if u want to close the connection u are required to close all existing recordsets also..

It's always adviced to close the connection whenever u are completed with the operation on the database ie right after the procedure call or command text call.. if u are not sure when then u can cooly write those statements at the end of the page..always whenever there is a error occurs have an error handler and check for the status of connections if they are open then close them in the error handling section.
_________________
Ambition Naver Comes to an End
anandham

[steve1]

Thanks Anandham

I'll close my ADO objects as soon as I'm done using them.




Thanks again,

Steve