I have some ASP's that use an Access database to store form info. The db connection info is in a separate file that I just #INCLUDE. Lateley I've seen error messages like 'File already in use' when an asp needs to read from the database. If the user refreshes the page, all works fine. Is this because only one person can access the #INCLUDE at a time? Is there a way around this? If this is not the cause, what could it be?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
#INCLUDE file problem 1
- Thread starter MikeT
- Start date
-
1
- #2
hi Mike,
I think that maybe the connection that you make is not being closed after each request. You need to code to close the connection to preserve server memory. You can close it after the code to present the data to the broswer. It sounds like you are hitting the include every time a request is made to the DB, so this is the best solution.
hth
Bastien
There are many ways to skin this cat,
but it still tastes like chicken
I think that maybe the connection that you make is not being closed after each request. You need to code to close the connection to preserve server memory. You can close it after the code to present the data to the broswer. It sounds like you are hitting the include every time a request is made to the DB, so this is the best solution.
hth
Bastien
There are many ways to skin this cat,
but it still tastes like chicken
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question