Connection question

[kathleenyanolatos]

I'm using ASP to connect to an Access 2003 database on a Microsoft
2003 server running IIS. To access the data, I open up a DNS-less
connection and use SQL queries to get the records. Many of the sites
have several queries and I'd like to know whether or not I should open
and close the connection for each query, open one connection for a
page and then close it at the end, or do something in between. Thank
you for your help!

 

[Douglas J. Steele]

I believe that the general advice is to open the connection when required,
and free it up when complete. If you're running your multiple queries one
after another in the same routine, a single connection should be okay. If
you move from routine to routine, you should probably limit the scope of
each connection to the single routine.

 

[kathleenyanolatos]

Thank you for the response. That's what I assumed, but I just wanted
to make sure I wasn't making a massive mistake.