keep open db connections

Mark,
this is a normal situation when page is loaded we open the connection and retrieve the data and close the connection. Wherever connection is actually open and closed every time - this is between the database driver and the database. Each one of them may have a connection pool and simply re-use one of the connections when requested.
What kind of problem are you trying to solve?

We were just trying to see about keeping connection open
have a heavy data entry app with lots of pages, so opening and closing DB's for each page takes it's toll on peformance
especially since IIS server is one, DB server is another, Client Browser is remote on diff network, etc...
Thanks for the info... now we know what to expect
Best

Mark