connection question

[Adam P]

Hey Everyone,

I am using enterprise edition. I have a simple question. Does aspdb automatically close the connection and set it to nothing after the page is executed?? If not, can I do it manually?? I am connecting to an access database and have to worry about the number of concurrent connections.

Thanks,
Adam Perfetti
adam@trinityhosting.com

[John]

Hi Adam,

The only time the data connection is open is during the call to ASPdbEP. We
do an Open, Read (or write, etc.) and Close all in that one call. By the time
your script resumes execution at the end of that call, the database is again
closed and ready to be used by another user.

When your object (i.e. MyDb) goes out of scope at the end of your page, it
is set to Nothing automatically by ASP so you don't need to do it there either.

Hope this helps!
John

------------
Adam P at 9/3/99 12:03:10 PM

Hey Everyone,

I am using enterprise edition. I have a simple question. Does aspdb automatically close the connection and set it to nothing after the page is executed?? If not, can I do it manually?? I am connecting to an access database and have to worry about the number of concurrent connections.

Thanks,
Adam Perfetti
adam@trinityhosting.com