Intermittent LDAP 'Table not found' error Rick E 6/6/2007 4:56:01 PM 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?

Re: Intermittent LDAP 'Table not found' error "CreateWindow" <createwindow[ at ]gmail.com> 6/8/2007 10:08:42 AM 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[ at ]discussions.microsoft.com> wrote in message news:176DD506-C519-4942-B1D5-BC7E24D97FF7[ at ]microsoft.com... [Quoted Text] > 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?

Re: Intermittent LDAP 'Table not found' error Rick E 6/8/2007 1:08:02 PM 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: [Quoted Text] > 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[ at ]discussions.microsoft.com> wrote in message > news:176DD506-C519-4942-B1D5-BC7E24D97FF7[ at ]microsoft.com... > > 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? > > >