Re: IIS 6.0 -> Server.CreateObject of ('null') !

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

From: Benny Hauk (BennyHauk_at_discussions.microsoft.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 15:01:02 -0700

Rolling back KB833987 and KB867460 did not seem to do the trick. The only
other thing done the night before the problem was that asp.net was registered
with IIS ('...\v1.1...\aspnet_regiis.exe -i'). I reregistered it (ran
'...\v1.1...\aspnet_regiis.exe -ua' and then '...\v1.1...\aspnet_regiis.exe
-i -enable' and then 'iisreset') and still seeing the problem.

One thing that has helped incredibly (now it only happens 2-4 times per day
verse 20-25) was that I put every app that had a problem in it's own App
Pool. My guess is that some problem occurs after either so much usage over
time or concurrently within a unique process and the thing starts crapping
out. Am considering rolling back all patches and reinstalling MDAC (assuming
that's possible with w2k3) and see how it goes, then start rolling patches
back on.

Actually, the first thing I'm going to do is do a restore from tape from
when it was behaving okay (to some temp drive) and start comparing files like
metabase.xml, registry hive exports, msado??.dll, etc.

More later as things develop...

-Benny

"Benny Hauk" wrote:

> Problem still occuring intermittently. Have tried breaking each application
> up into different application pools and various applications (now across App
> Pools) are still failing. Absolutely every time it is the "Set Connection =
> CreateObject("ADODB.Connection")" line that fails. No connection attempt
> made, just trying to create a connection intance.
>
> I finally noticed that 1) 2 security patches were installed the evening
> before the problem started (KB833987 and KB867460) and 2) the server hasn't
> been rebooted since then.
>
> I am going to reboot tonight and see if problem persists. If it does then I
> am going to uninstall the patches and see if problem persists. I feel good
> about one of those 2 things fixing the problem.
>
> This thread I found is related since the problems seen were brought on by
> the same things that were installed right before when I started seeing my
> problems:
> http://dotnet.meetholland.com/message/146160.aspx
>
> This threads all describe the exact same problem I am observing.
> Unfortunately none include a response (the most recent is from Sept, which is
> discouraging, but the problem description is right on the money):
> http://groups.google.com/groups?hl=en&lr=&threadm=ba1ddf27.0302100738.a32af89%40posting.google.com&rnum=1&prev=/groups%3Fq%3Dc0000005%2520%2522ADODB.Connection%2522%2520%2522Server.CreateObject%2520Failed%2522%26hl%3Den%26lr%3D%26sa%3DN%26tab%3Dwg
> http://groups.google.com/groups?hl=en&lr=&threadm=024401c2d9ef%24bdb8ef20%24a301280a%40phx.gbl&rnum=3&prev=/groups%3Fq%3Dc0000005%2520%2522ADODB.Connection%2522%2520%2522Server.CreateObject%2520Failed%2522%26hl%3Den%26lr%3D%26sa%3DN%26tab%3Dwg
> http://groups.google.com/groups?hl=en&lr=&threadm=azCD7.31047%24GA.4243379%40news2-win.server.ntlworld.com&rnum=4&prev=/groups%3Fq%3Dc0000005%2520%2522ADODB.Connection%2522%2520%2522Server.CreateObject%2520Failed%2522%26hl%3Den%26lr%3D%26sa%3DN%26tab%3Dwg
> http://groups.google.com/groups?hl=en&lr=&threadm=601601c15695%24402f92e0%249ae62ecf%40tkmsftngxa02&rnum=6&prev=/groups%3Fq%3Dc0000005%2520%2522ADODB.Connection%2522%2520%2522Server.CreateObject%2520Failed%2522%26hl%3Den%26lr%3D%26sa%3DN%26tab%3Dwg
>
>
> "Egbert Nierop (MVP for IIS)" wrote:
>
> > "Benny Hauk" <Benny Hauk@discussions.microsoft.com> wrote in message
> > news:AF0E7FE8-13FB-4F68-88D8-A5CDD2C19ED7@microsoft.com...
> > > So the rule of thumb that's been around for a few years (use
> > > Server.CreateObject in lieu of just CreateObject) is the other way around
> > > in
> > > IIS 6?
> >
> >
> > Since IIS5 and higher, you don't need Server.CreateObject only for objects
> > that use legacy interfaces. But ADO never did.
> >
> > So what is your error message now? Does it work now?
> >
> > > I had the same problem originally described (web server would occasionally
> > > go into a state of throwing ASP 0117 and ASP 0241 errors when certain apps
> > > would run 'set conn = Server.CreateObject("ADODB.Connection")'). This
> > > started happening only after migrating a web server from W2k to W2k3. To
> > > fix
> > > the problem I changed IIS6 to run in IIS 5 Isolation Mode insead of using
> > > Application Pools and worker processes. I sacrifice a lot to do this, but
> > > I've gotta go with what works. I suspect it could have been an access
> > > issue.
> > > The application pools were running in the context of the Network Service
> > > (the default), not the IWAM account.
> > >
> > > I've run into similar conflicts when using application pools with more
> > > than
> > > 1 worker process (not the case in this instance). My own rule of thumb:
> > > If
> > > it's legacy asp, only run it in an App Pool with 1 worker process
> > > otherwise
> > > you will run into intermittent problems.
> > >
> > > My experience thus far: Much easier to deal with IIS 5.x than IIS 6. I
> > > guess it is understandable in a sense, but still unfortunate.
> > >
> > > "Egbert Nierop (MVP for IIS)" wrote:
> > >
> > >> First you should understand that server.createobject was meant for IIS
> > >> 3.0
> > >> and 4.0 backward compatibility.
> > >> In short, it does a lot more code behind the scene that you don't need.
> > >> So change that to
> > >> Set Connection = CreateObject("ADODB.Connection")
> > >>
> > >> After that you might see other behaviour however, the problem you
> > >> describe
> > >> should not happen.
> > >>
> > >> --
> > >> compatible web farm Session replacement for Asp and Asp.Net
> > >> http://www.nieropwebconsult.nl/asp_session_manager.htm
> > >>
> > >> "Henrique Soler Albano" <henriquecns@consciencia.com.br> wrote in message
> > >> news:uWmq1j9qEHA.4008@TK2MSFTNGP14.phx.gbl...
> > >> > Hello there,
> > >> >
> > >> > I'm having problems with Server.CreateObject on IIS 6.0.
> > >> >
> > >> > When I start my app everithing works fine. The problem occurs after
> > >> > using the app for many times.
> > >> >
> > >> > I tougth that was some kind of problem with ADODB.Connection but I
> > >> > saw
> > >> > on web many friends having the same problem with different objects
> > >> > server
> > >> > creations (file system object, adodb connections, cdonts mailer, etc).
> > >> >
> > >> > It ocurrs exactly in the adodb.connection creation line: Set
> > >> > Connection
> > >> > = Server.CreateObject("adodb.connection")
> > >> >
> > >> > It's strange, the server is telling me that there is an instruction
> > >> > to
> > >> > create a null object in my code.
> > >> >
> > >> > It seems to be a security limitation of IIS 6.0.
> > >> >
> > >> > Here is the error return page from the webserver (Brazilian
> > >> > Portuguese):
> > >> >
> > >> > *******************************************
> > >> >
> > >> > CreateObject of '(null)' caused exception C0000005.
> > >> >
> > >> > Server Object error 'ASP 0177 : c0000005'
> > >> >
> > >> > Falha em Server.CreateObject
> > >> >
> > >> > /Online/Global/ini_x.asp, line 67
> > >> >
> > >> > c0000005
> > >> >
> > >> > *******************************************
> > >> >
> > >> > Does anybody has an idea about it?
> > >> >
> > >> > Thanks in advance.
> > >> >
> > >> > Henrique Piolho
> > >> >
> > >> >
> > >>
> > >>
> >
> >

Relevant Pages

  • Re: Saved Word Docs are coming up with a blank blue screen?
    ... it suggests that something is corrupted in the registry: you should be able to resolve this by rolling back to a restore point previous to the the problem. ...
    (microsoft.public.word.application.errors)
  • Re: A Virgins Tale
    ... fooling around with toons I know are less than two weeks away from ... annihilation. ... But since Turbine's still rolling out the patches, ...
    (comp.sys.ibm.pc.games.rpg)
  • RE: Rolling out patches
    ... >Subject: Rolling out patches ... >Do You Yahoo!? ... Health - your guide to health and wellness ...
    (Focus-Microsoft)
  • Re: Rolling out patches
    ... >What is your favorite tool/techniquefor rolling ... >Do You Yahoo!? ... Health - your guide to health and wellness ... with both NT and 2k and installs os and iis/sql 7 patches ...
    (Focus-Microsoft)
  • [Xnews] Icon patch for 2005.09.25?
    ... (Not wanting to sound like a typical 'net lazy-greedy-do-nothing! ... But I really liked the patches for prior versions, ... rolling my own ...) ...
    (news.software.readers)