• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

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?
0
Graeme
Asked:
Graeme
  • 8
  • 6
1 Solution
 
Ryan ChongCommented:
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 ChongCommented:
>>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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
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 ChongCommented:
>>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 ChongCommented:
>>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 ChongCommented:
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
 
Ryan ChongCommented:
hope your application is stable now. do you need further assistance here?
0
 
Graemewebber4technologiesAuthor Commented:
figured it out myself
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now