IIS 5.0 and ADO locking up

I've run into this problem recently and I haven't been
able to pin it on anything. I've been doing ADO
connections to Access databases for small databases
before, but now they aren't working. I've double-checked
the ASP code on two different pages, one that works and
the new one and they are completely similar, I've even
copied it over, but changed the paths. Here is a sample:

<% Do While Not rsCat.EOF %>
<!-- code here -->
<% rsCat.MoveNext
Loop %>

If I remove that part of the code the page works fine, but
obviously doesn't show anything. The problem I'm having is
that this will lock up the current site on my web server
until I restart the site. I also get a few errors in the
system event log such as Event ID 37, "Out of process
application '/LM/W3SVC/1/Root' terminated unexpectedly."
or "The Remote Procedure Call Failed and Did Not Execute."
in the browser. The only help I've come across is that a
possible Microsoft Patch for RPC could have caused it.
I've updated to MDAC 2.8 on a different web server, but it
seems to still have the same issues. The databases created
earlier and the ASP pages they use still work fine, it
seems to be anything I try to create now. Thanks in
advance for any insight.

Dev
Thu Oct 30 09:41:54 CST 2003

Brian,

If your server is crashing or hanging you might want to
download our ReJuvin8 tool. It's designed to detect then
restart or reboot. It doesn't fix root problems but it
does give you some breathing room while you are addressing
them. ReJuvin8 also gives you email and telephone alert
messages of what it's doing. Use it free for the first
15-days.


ReJuvin8 has both an automatic detect mode and a custom one.
In the auto mode you make all the settings by pointing and
clicking. This will handle most applications.

In the custom mode you can include heartbeat synch
files which give you absolute detection that certain functions
are working. ReJuvin8 includes tools and instructions to help
you do this. Need to get going immediately? We will contract
to set it up for you at your site.

Charles

voice: (530) 477-7327
email: supportREMOVE@amfox.com
(Please delete the 'REMOVE' from the email address.)

Download: http://www.amfox.com/rejuve/rj8a.asp?acode=t1




"Brian Z" <bzalewski@journalbroadcastgroup.com> wrote in message
news:183d01c39e41$cec0f1c0$3101280a@phx.gbl...
> I've run into this problem recently and I haven't been
> able to pin it on anything. I've been doing ADO
> connections to Access databases for small databases
> before, but now they aren't working. I've double-checked
> the ASP code on two different pages, one that works and
> the new one and they are completely similar, I've even
> copied it over, but changed the paths. Here is a sample:
>
> <% Do While Not rsCat.EOF %>
> <!-- code here -->
> <% rsCat.MoveNext
> Loop %>
>
> If I remove that part of the code the page works fine, but
> obviously doesn't show anything. The problem I'm having is
> that this will lock up the current site on my web server
> until I restart the site. I also get a few errors in the
> system event log such as Event ID 37, "Out of process
> application '/LM/W3SVC/1/Root' terminated unexpectedly."
> or "The Remote Procedure Call Failed and Did Not Execute."
> in the browser. The only help I've come across is that a
> possible Microsoft Patch for RPC could have caused it.
> I've updated to MDAC 2.8 on a different web server, but it
> seems to still have the same issues. The databases created
> earlier and the ASP pages they use still work fine, it
> seems to be anything I try to create now. Thanks in
> advance for any insight.