Re: Intermittent LDAP 'Table not found' error
- From: Rick E <RickE@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 8 Jun 2007 06:08:02 -0700
I found the solution myself so I'll post what I found in case any one else is
having this problem.
In the security settings for the page under IISMGR I had set the credentials
to run under "Enable Anonymous Access" but the lower section labeled
"Authenticated Access", which should be ignored if you're using Anonymous
above, still had the "Integrated Windows Authentication" checked. Once I
UNchecked this box, its stable now. You can even see this beahvior in the
piece of the logs I posted as during the inital failed attempts you can see
the site was trying to proces the credentials of the user running the page
(domain\userid) but these disappear when the page runs correctly.
"CreateWindow" wrote:
Hi Rick,.
I have no idea why this is intermittent. It sounds like a fragile network
problem of some kind. Have you considered using a component like Justldap
which runs in a COM+ package? (This is a shameless plug for something I
wrote. But when I saw "classic ASP" - I couldn't resist. 1000 appologies to
the group - I'll make it up in due course :) Anyhow, below is a _free_ cool
Web page checker.
CreateWindow
http://justpageprobe.com
The FREE Web page utility you always wanted.
Monitor your enterprise Web Servers.
Keep your router connected.
Email your IP to where you need it.
"Rick E" <RickE@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:176DD506-C519-4942-B1D5-BC7E24D97FF7@xxxxxxxxxxxxxxxx
We have a "classic" ASP page running on IIS 6 server, Win2003 server which
querries AD for information for string of a user name passed. This page
is
called from a page that runs under the user's security (anonymous access
disabled) but then this page has anonymous enabled with a LAN id
credentials
stored with the properties of the page (not passed via code but rather in
the
IISMGR GUI).
Without changing code or credentials, the above setup works and then
doesn't
work. When it does not work the get the error "Provider error '80040e37',
Table does not exist". It of course fails on our Set rsADuser =
command.Execute line of code but of course we know the syntax is good
because
it works other times.
From IE 6, refresh or Ctrl-refresh don't help but if you HOLD DOWN F5
(refresh) for 2 seconds then let it go, it works.
From our IIS log (removing irrelevant data) we see the following entries
for
the above (hold F5 down) action:
GET /folder/page.asp |101|80040e37Table_does_not_exist. 80 domain\userid
ip ....... 500 0 0
GET /folder/page.asp |101|80040e37Table_does_not_exist. 80 domain\userid
ip ....... 500 0 0
GET /folder/page.asp |101|80040e37Table_does_not_exist. 80 domain\userid
ip ....... 500 0 64
GET /folder/page.asp 80 - ip .....200 0 64
GET /folder/page.asp 80 - ip .....200 0 64
GET /folder/page.asp 80 - ip .....200 0 64
GET /folder/page.asp 80 - ip .....200 0 64
GET /folder/page.asp 80 - ip .....200 0 64
You can see a shift in the status codes at the end to cause it to start
working but there's no other messages.
It feels like a timing issue between the server(s). Anything I can check?
- References:
- Re: Intermittent LDAP 'Table not found' error
- From: CreateWindow
- Re: Intermittent LDAP 'Table not found' error
- Prev by Date: Re: monitor for file creation using variables
- Next by Date: Clearing DNS Suffix search order
- Previous by thread: Re: Intermittent LDAP 'Table not found' error
- Next by thread: Re: Move client printers to different print server
- Index(es):
Relevant Pages
|