Should I always use connection.close

Question

• Should I always close my db connection or close automatically?

• What happens if I don’t close it?

• How can I close the connection in case of asp error? I do not want to use the "on error goto next" command, but stop the script if an error occurs.

• How is automatic closure different from SQL Server 2008 and 2012?

Answer 1

• Yes, you should always try to close everything that you open. By doing this as early as possible, resources are allocated in the code that can be reused by other requests.

• , , , ASP- ( , , ), , script . , , , .

• . , script , , .

• . ASP ADODB SQL Server, .