Free a "Set" object

[DougP]

I have several &quot;Set&quot; commands<br>What is the best way to free these?<br><br>Set Conn = server.CreateObject(&quot;ADODB.Connection&quot<br>Conn.Open &quot;driver=SQL Server;server=clh.ij.net;uid=universal1;pwd=ULS1;database=Universal1;&quot;<br>Set RS1 = &quot;blah blah...&quot;<br>...<br>Set Mail = Server.CreateObject(&quot;Persits.MailSender&quot<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[palbano]

Dear Doug,<br><br>I don't do VBScript but I think it is:<br><br>Set Conn = nothing<br><br>-pete<br><br>

 

[Jordi]

Hi DougP !<br><br>For free the memory space occupied for the object definition maked with the SET instruction, you must do<br><br>&nbsp;&nbsp;&nbsp;&nbsp;SET obj_name = NOTHING<br><br>Is not necessary to do it if the object definition is inside a function or a Sub procedure because when you end the execution of then, the object will be destroyed and the memory libered.<br><br>Regards.<br><br>Jordi. <p>Jordi<br><a href=mailto:jorgepalacioscalvo@yahoo.com>jorgepalacioscalvo@yahoo.com</a><br><a href= > </a><br>Visit you Spain, the sun's country!