• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

Closing Recordsets and Database Connections

I am currently using classic ASP and I was hoping I could get a question answered:

What happens if I do not close a database connection or a recordset?  Will the database connection and recordsets get automatically closed at the end of the classic ASP script?

Thanks!
0
nickgross19
Asked:
nickgross19
1 Solution
 
pritamduttCommented:
Do database connections close automatically .. The answer for this yes and no...

Yes they get closed automatically after a time out
No they don't get closed automatically at the end of the classic ASP script

Also note If you do not close your database connections, many problems can occur like web pages hanging, slow page loads, and more.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now