Resources Exceeded

[maduko]

I have a web server (Win 2k3, IIS6) with three sites using Access databases. Today they suddenly slowed to a crawl and one won't load at all- it shows the following error:

Microsoft JET Database Engine error '80004005'

System resource exceeded.

/gear/show.asp, line 18

As far as I know all of my data pages close their connections. I've checked disk space and looked for temp files but nothing looks out of the ordinary. I plan to move all this over to SQL soon, but for now I have to make it work.

Is there any way to identify open data connections?

How can I stop the error?

 

[PHV]

How can I stop the error
Reboot the web server ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JoeAtWork]

Have you Googled this yet? Because in a quick 2-minute search I've found two references to this error, both suggesting the solution is to use the OLEDB JET driver instead of the ODBC driver.

http://kb.webecs.com/article.aspx?id=10100

http://aspalliance.com/14

 

[maduko]

I was hoping to avoid a reboot if possible. I tried restarting the site but it didn't help. I recycled the worker process and that seems to have worked for now.

Thanks for the links. Already seen them- I'm already using OLE DB for all connections and nothing I found explained how to monitor active connections.