I'm looking for some information regarding connection theory using the ODBC API.

Is it common and/or customary to close a connection once a result set is returned and then reopen the connection to perhaps
write the result set back? Most the examples I've seen seem to do a lot of opening and closing of connections which must generate
mucho network traffic. Are these examples taking connection pooling into consideration? Is it true a single connection can maintain
multiple statements? Any comments would be greatly appreciated.

The target is SQL 7, NT 4.0, ODBC 3.51

Thank you.