• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1135
  • Last Modified:

Query of Active Directory began failing yesterday: Table does not exist.

We have a classic ASP page that was working great until yesterday.  It does a user lookup against Active Directory ... doing a SQL-like query using the ADsDSOObject provider.

The query is:
select cn, mail from 'GC://10.XX.YY.ZZ' where cn = 'wilson*' or sn = 'wilson*' order by sn

(internal IP address munged ... it's really a full IP)

The error is:
Error Type:
Provider (0x80040E37)
Table does not exist.

I know that over the weekend the infrastructure team applied a bunch of patches.  But I need them to specifically look for ... something.

What should I have them looking for?  Changing a global catalog server?  Changing a primary role holder?

Thanks!
0
Daniel Wilson
Asked:
Daniel Wilson
  • 2
  • 2
2 Solutions
 
David LeeCommented:
Hi, DanielWilson.

The error says that either the server doesn't exist, i.e. the address has changed, or the server is not a GC, or it was not contactable.  So, to start off, I'd check the to make the server has the correct IP address, that it is a GC, and that it can be seen on the network.
0
 
Daniel WilsonAuthor Commented:
Ok, a domain admin just gave me a different IP ... that worked.

So it appears the server I was using either got taken off the network, IP changed, or quit being a GC?
0
 
David LeeCommented:
Correct.
0
 
Darksied9Commented:
Yeah that is the issue.  I would not use the IP, but rather the FDQN for the Domain itself.  If your domain is int.computer.com put that in... That will guarantee that you always hit a valid GC.
0
 
Daniel WilsonAuthor Commented:
Thanks, guys!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now