Garbage collection for db connection objects

[multiplex77]

Hi,

What would be the negative consequences of not doing garbage collection for database connection objects and recordsets? (i.e., closing them and setting them to Nothing)

Also, is it okay to

Set connectionObj = Nothing

And

Set recordsetObj = Nothing

without first doing

connectionObj.Close and recordsetObj.close?

Thanks for the advice!

 

[exodus300]

Why? You might as well just do it anyway to reduce the chance of negative consequences. It's only 4 lines of typing. [Thanks in advance|Hope I helped you]
Exodus300
World-Wide Alliance of Evil and Twisted People
[red]"Experimentation by Example is the best learning tool" - Exodus300[/red]

 

[snowboardr]

It releases it from memory, thus freeing up resources. www.vzio.com

/