First of all, hello to all

For years i used to write macros in vba in excel. Recently it just happened to deal with vb6, and now, as a newbie in this, i want to ask the following.
I'm developing an application, as soon as the main form loads (MDI form), the app connects to db. I use ADO connection. The connection to the db is closed by the time the app closes, and never before this. Is that right? Should i connect/disconnect from db as soon as i finish with procedures?
Also, when setting recordsets, right before closing procedure, I set them back to nothing. I guess that's what it has to be done?

Thank you in advance.
(I hope i posted in the right session.. or is it for VB6 forum?)