Re: Intermittent LDAP 'Table not found' error



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?



.



Relevant Pages

  • Re: credentials prompt accessing list anonymously
    ... Anonymous users, for those Lists, have been given the additional Add Items ... permission (in addition to the default Read permissions). ... All they they have by default in a site accessible by anonymous access ... Reader functionality without needing to give credentials. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Windows XP (IIS 5) and ASP.NET 2.0 Application?
    ... browse to the Virtual Directories under my IIS installation (that were setup ... even when supplying the correct credentials). ... Anonymous Access) and now I keep getting prompted for credentials every ... However, when I run Internet Explorer as "Administrator", I see my site ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: credentials prompt accessing list anonymously
    ... So in my opinion the credential prompt is still "surprising." ... I have discovered a bug with anonymous access on Portal server 2003. ... access without restarting IIS, but once the process restarts on its own, I'm ... Reader functionality without needing to give credentials. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: credentials prompt accessing list anonymously
    ... Even if you have given then Add functionality, they will still need to sign in to get it. ... So unless you have amended anonymous access so that anonymous people have Contributor rights, these people you have given add rights will still need to specify their name and password before being allowed to add anything. ... The workaround - can make it work like I want for a short time by disableing Anonymous access, restarting IIS and then enableing anonymous access without restarting IIS, but once the process restarts on its own, I'm back to square one. ... Reader functionality without needing to give credentials. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: credentials
    ... Change your Security Settings for Internet Explorer. ... In the Custom Level ... By default it is set to use your current Domain login credentials ... > I used to identify to the server as the administrator of the ...
    (microsoft.public.sharepoint.portalserver)