Multiple DB Connects

A general question......During the processing of an ASP page, if u have to make up to say, five calls to the DB to retrieve data from different tables, should u make one connection at the beginning of the form with recordset calls to the different tables and THEN close the conn at the end of the form, or should u make and close each connection to a table before moving to the next table. Is the multiple conns/breaks on the form puting a lot of unnecessary work on the server? or is the pracatise of keeping the conn open from beginning to end of a form dangerous if there is an error, and the conn remain open. any thoughts??....>>

You might be best posting this in the ASP forum. Generally speaking, opening a single connection and closing it right at the very end will make coding much more straightforward without slowing your application at all. It also helps connection pooling to work more efficiently

OK Mike, no that answers the question, i dont need to re-post it...many thanks for clearing that up...i now have a lot of forms to go and tidy up !....many thanks...>>>>