Re: Il this the IIS Jet bug ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Martuk (martuk_at_club-internet.fr)
Date: 06/02/04 

Date: 2 Jun 2004 02:28:00 -0700

Hi Pat,
Upgrading the MDAC from 2.7 to 2.8 did not fix the bug. So, we
consider moving to MSDE as you advised. But, we need to be sure enough
that the bug will disappear ! Or my boss could beat me ;)
So, IYO is it possible that the bug be created by incorrect ASP code
somewhat ? Or by bad ADO use ? We also have some VB DLLs with ASP and
ADO.
There is no other symptoms than :
- IIS stopping serving ASP pages
- IIS working again after DllHost being closed in the task manager, or
the site unloaded in the Internet service manager.

"Pat [MSFT]" <patfilot@online.microsoft.com> wrote in message news:<u$EDF4iPEHA.3052@TK2MSFTNGP09.phx.gbl>...
> That's pretty heavy load for Access. MSDE would probably do just fine (and
> get you the SQL libraries which scale better). You can also try running the
> DB compaction against the DB's. You should do this weekly for Access
> (MSDE/SQL doesn't require this).
>
>
> Pat
>
>
>
> "Martuk" <martuk@club-internet.fr> wrote in message
> news:fe7a91d6.0405190011.452b9688@posting.google.com...
> > Thanks Pat, I am installing MDAC 2.8. (But it's not the bug with the
> > weird ADO syntax MDAC 2.8 is supposed to solve - I never used that
> > syntax).
> >
> > The bug occurs 1-2 times a day, apparently mostly when the charge is
> > about 15 sessions at once. For instance, when most users were on
> > holidays it did not happen for a week.
> > Do you think the charge is too heavy for Jet and moving to another
> > database would solve the problem ?
> >
> > "Pat [MSFT]" <patfilot@online.microsoft.com> wrote in message
> news:<O1ZVaTPPEHA.2452@TK2MSFTNGP11.phx.gbl>...
> > > It's not the Jet bug. This looks like Jet is working OK, but is
> blocking
> > > because of some MDAC activity. I would suggest upgrading MDAC
> > > (www.microsoft.com/data) and see if that helps.
> > >
> > >
> > > Pat

Relevant Pages