View Single Post
  #1 (permalink)  
Old 07-06-04, 06:46 AM
ziadn ziadn is offline
New Member
 
Join Date: Jan 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Question Active Directory Error

I am doing some authentication against the Active Directory, but am (for some users only ) getting the following error:

Provider (0x80040E37)
Table does not exist.

More specifically:
- The page is accessed internally (company-wide)
- All employees are logged in to the same domain (but from different locations).
- The error is generated for some employees only, but I can't pinpoint any difference between those employees and others for which the page works.
- Anonymous access is disabled in IIS
- This is running under a W2K server using IIS 5.0

Any idea why it is working for some users but not for others?

Thanks,

Ziad


Here is the relevant part of the code:

Code:
 
DomainName = Application("myDomainName")
strDefaultNamingContext = Application("myDefaultNamingContext")
GALQueryFilter = "(&(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(!(homeMDB=*))(!(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=contact))(objectCategory=group)(objectCategory=publicFolder) )))(objectCategory=user)(postalCode=" + employee_id + ")))"
strQuery = "<LDAP://" & DomainName & "/" & strDefaultNamingContext & ">;" & GALQueryFilter & ";sAMAccountName;subtree"
Set oConn = CreateObject("ADODB.Connection")
oConn.Provider = "ADsDSOOBJECT"
oConn.Open "ADs Provider"
Set oComm = CreateObject("ADODB.Command")
oComm.ActiveConnection = oConn
oComm.Properties("Page Size") = 1000
oComm.CommandText = strQuery
Set rs = oComm.Execute

Last edited by ziadn; 07-06-04 at 06:51 AM.
Reply With Quote