By proactively closing connections when they are no longer needed, you reduce demand on the database server and make resources available to other users. Connections are closed when they go out of scope, but you can use the Close method to close a connection at any time.
The following code creates a Command object, implicitly creates a new connection, and calls a stored procedure:
<% Set cmd = Server.CreateObject(