Database and Recordset Connections

I am using a VB6 frontend to a SQL server 2000 backend. What is good coding
and development practice with regards to when to open/close any database
connections? I am using ADO.
Do you always close the entire database link each time you close a
recordset, or only at the end of the application?
Just looking for some best practices.
Thanks
David
Message posted via http://www.droptable.comHi
Frolm a VB6 application I would re-use the connection and close it at the
end.
John
"David Oberer via droptable.com" <forum@.droptable.com> wrote in message
news:83108ed341584a39910e7dbe1b333300@.SQ
droptable.com...
>I am using a VB6 frontend to a SQL server 2000 backend. What is good coding
> and development practice with regards to when to open/close any database
> connections? I am using ADO.
> Do you always close the entire database link each time you close a
> recordset, or only at the end of the application?
> Just looking for some best practices.
> Thanks
> David
> --
> Message posted via http://www.droptable.com