Hi,<BR>I have a doubt regarding the process of clearing the connection object. Lets say after creating the connection object , I don't close the connection and directly set that to nothing, then will it cause any problem. For example...<BR>set conn=server.createobject("ADODB.Connection")<BR>co nn.open ....<BR>conn.execute(...)<BR><BR>set conn = nothing, Instead of conn.close , I am directly setting it to nothing. <BR>So do I need to use two statements to completely clear the conn object? ( I am not using this object instance to open any other database connection.) <BR><BR>Thanks in advance..