IIS Freezing, Access opening .lbd file

Hi there, I have not had this issue up until about 1 month ago

my IIS is freezing due to the access databases opening its .ldb file (i can confirm that it is not being opened locally nor over the network)

to fix this I need to restart the Web Service on SBS2003, but shortly after it will freeze again.

Any ideas of what it could be? perhaps some code that is running wild?
Graemewebber4technologiesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
it seems that your Access dB was opened but it was not being closed while you try to access it via asp codes.

can you check your codes and make sure the connection to dB is closed after using it?

try to delete that .lbd file after ur server is rebooted and see if the problem persists?
0
Graemewebber4technologiesAuthor Commented:
Hi Ryan, i have tried to delete it before, however only a reboot or restart the web service will get rid of it

How do you mean the dB being closed after using it ?

Cheers
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>How do you mean the dB being closed after using it ?

I mean if you got a ADODB.connection object, do you close that connection after using it? like:

set Conn = server.createobject("adodb.connection")
Conn.open connstr
....

Conn.close '<< this line
set Conn = nothing
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

Graemewebber4technologiesAuthor Commented:
No I have never done that.

would that be the reason why its been happening in the last month and not last 2 years?
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>would that be the reason why its been happening in the last month and not last 2 years?

certainly I didn't know the exact reason as I can't access to your server for verification.

but it would be a good practice to close the connection after the usage.
1
Graemewebber4technologiesAuthor Commented:
I suppose it wouldnt hurt to give it ago :)

Im guessing i put it at the bottom on the page?
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
>>Im guessing i put it at the bottom on the page?
yes you can, or any other places in which you no longer need to access to the dB.
0
Graemewebber4technologiesAuthor Commented:
Thanks for that Ryan, im going to apply and monitor over next few days (fingers crossed it works!)
0
Graemewebber4technologiesAuthor Commented:
after applying the code, still having the same issues. had 7 lock ups since applying. So Im guessing its not that

any other ideas? or other information you want me to show you?
0
Graemewebber4technologiesAuthor Commented:
I have been doing some investigating...

and have found that possibly the google web crawler might be the issue?

Sound plausible?
0
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
any other ideas? or other information you want me to show you?

and have found that possibly the google web crawler might be the issue?

just a guessing... what if you changed the path of database? would same issue happened?
0
Graemewebber4technologiesAuthor Commented:
I think I have figured out what the issue was...

one of the databases that was being accessed looks like it has a corrupt table that was unable to be written to

have changed some things so it no longer writes to that table, hopefully this fixes it

going to monitor over next few days first - then try your suggestion of changing path Ryan
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
hope your application is stable now. do you need further assistance here?
0
Graemewebber4technologiesAuthor Commented:
figured it out myself
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.