Re: Intermittent LDAP 'Table not found' error



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?


.


Loading