What happens when you don't close a recordset or connection?

[heavenly_blue]

When using things like this...

Set conWhatever = Server.CreateObject("ADODB.Connection")
Set rstWhatever = Server.CreateObject("ADODB.RecordSet")

...what kind of bad things actually happen when they are not closed in the script?

Do I need to close them AND set them = Nothing, or does it even matter?

[buntine]

By convention, its best to do both. The objects will take up space in memory after you are finished with them. Your Web Site will run slowly if too much memory is consumed.

And afterall, there is no use having objects lying around taking up space if you dont need them again.

Regards.