idle connection

[Guest]

Hi!

I am developing a web site using ASP as FE and Access as BE, connecting to
Access using Jet.

Is there any way to check if there is any idle database connection hold by
users? Although I try to close all connection at the end of each page, I am
worrying about if I have miss out some of the connections. I afraid the
system would run out of resource by those idle connections.

If a user close the browser before finish loading the page (before the close
connection statement), would the database connection be closed at the same
time?

Would idle database connection timeout? If so, what is the default time limit?

Thanks!

 

[Ron Hinds]

I've had websites like that up and running for years and never experienced
any problems with too many connections. I wouldn't worry about it...