ASP (not Asp.Net) database best practice?

[nick]

Will the object variables of

Connection, - Server.CreateObject("ADODB.Connection")
Recordset - Server.CreateObject("ADODB.Recordset")
and Command - Server.CreateObject("ADODB.Command")

be automatically released after the asp page finished running or error
exception (e.g. the database get down)?

I've the following function:
function openRS(conn, strCmd, item)
{
var cmd = Server.CreateObject("ADODB.Command")
var rs = Server.CreateObject("ADODB.Recordset")

rs.CursorType = adOpenForwardOnly
rs.LockType = adLockReadOnly

cmd.ActiveConnection = conn
cmd.CommandText = strCmd
cmd.CommandType = adCmdStoredProc

// Parameter pItem
var param = cmd.CreateParameter("@pItem",adVarChar,adParamInpu t,50,"")
cmd.Parameters.Append(param)
cmd.Parameters("@pItem") = item

rs.Open(cmd)

return rs
}

For example, if I never do "cmd = null" right after rs.Open(cmd), can it
causes problem? or ASP will automatically release it after run or error
exception?

[Bob Barrows [MVP]]

nick wrote:

> Will the object variables of
>
> Connection, - Server.CreateObject("ADODB.Connection")
> Recordset - Server.CreateObject("ADODB.Recordset")
> and Command - Server.CreateObject("ADODB.Command")
>
> be automatically released after the asp page finished running or error
> exception (e.g. the database get down)?
>

See
[url]http://blogs.msdn.com/ericlippert/archive/2003/09/17/53038.aspx[/url]
and
[url]http://blogs.msdn.com/ericlippert/archive/2004/04/28/122259.aspx[/url]


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[nick]

Bob Barrows [MVP] wrote:

> nick wrote:
>

>>Will the object variables of
>>
>>Connection, - Server.CreateObject("ADODB.Connection")
>>Recordset - Server.CreateObject("ADODB.Recordset")
>>and Command - Server.CreateObject("ADODB.Command")
>>
>>be automatically released after the asp page finished running or error
>>exception (e.g. the database get down)?
>>

>
>
> See
> [url]http://blogs.msdn.com/ericlippert/archive/2003/09/17/53038.aspx[/url]
> and
> [url]http://blogs.msdn.com/ericlippert/archive/2004/04/28/122259.aspx[/url]
>
>

Thanks.

So according to the links. I needn't do
cmd = null
in my example.

And I even needn't worry about using Jscript's
try {... database }
Finally { code to close connection, release database objects....}
to handle exceptions of database?

[Bob Barrows [MVP]]

nick wrote:

> Bob Barrows [MVP] wrote:
>

>> nick wrote:
>>

>>> Will the object variables of
>>>
>>> Connection, - Server.CreateObject("ADODB.Connection")
>>> Recordset - Server.CreateObject("ADODB.Recordset")
>>> and Command - Server.CreateObject("ADODB.Command")
>>>
>>> be automatically released after the asp page finished running or
>>> error exception (e.g. the database get down)?
>>>

>>
>>
>> See
>> [url]http://blogs.msdn.com/ericlippert/archive/2003/09/17/53038.aspx[/url]
>> and
>> [url]http://blogs.msdn.com/ericlippert/archive/2004/04/28/122259.aspx[/url]
>>
>>

>
> Thanks.
>
> So according to the links. I needn't do
> cmd = null
> in my example.

It can't hurt, but is probably unnecessary.

>
> And I even needn't worry about using Jscript's
> try {... database }
> Finally { code to close connection, release database objects....}
> to handle exceptions of database?

You should always explicitly close and destroy your ADO recordsets and
connections (make sure you digest the part about circular references - child
objects should be cleaned before parent objects. Failure to adhere to this
can lead to memory leaks that can crash IIS) as early as possible to allow
the connections to go back into the connection pool to be used by other
threads. I would not wait until a Finally block to close them if there will
be a large amount of code to run before the Finally block is reached. One of
the main points made in the second link is the need/desirability to free
expensive resources as early as possible. This consideration should not be
ignored.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.