Hi all.<BR>In short, I receive the table does not exist error with my asp code that is supposed to query AD. This identical code works flawlessly on a different box, so maybe there is some setting in IIS that is incorrect. However, I have tried and tried again using the settings that are supposed to be correct. (Using clear text/basic auth in your IIS settings) I have done the following:<BR><BR>- ensured ADSI is installed (it is)<BR>- turned on clear text/basic auth<BR>- tried this is integrated windows authentiation on and off<BR>- tried this with anonyomous on and off<BR><BR>I&#039;m not really sure what else it could be. Even more troubling is this,<BR>If I put it my code (which is below) on our old server, it works fine. On my dev server, it does not function only returns this error:<BR><BR>Error Type:<BR>Provider (0x80040E37)<BR>Table does not exist.<BR>/test3.asp, line 15<BR><BR>here is the code just in case:<BR>
<BR>&#060;%@ Language=VBScript %&#062;<BR> <BR>&#060;%<BR>Function xdirlookup(uid, fld)<BR>Dim conn, cmd, rs, i<BR>    Set conn = CreateObject("ADODB.Connection")<BR>    Set cmd = CreateObject("ADODB.Command")<BR>    conn.Provider = "ADSDSOObject"<BR> <BR>    conn.Open "Active Directory Provider","DC=DOMAIN,CN=USERNAME","PASSWORD"<BR>    Set cmd.ActiveConnection = conn<BR>    cmd.CommandText = "&#060;LDAP://SERVER_NAME&#062;;(&(objectClass=organizationalPerson)(uid=" & uid & "));uid,sn,givenName,mail;subtree"<BR>    Set rs = cmd.Execute<BR>    <BR>    If (Not (rs.EOF And rs.BOF)) Then<BR>        xdirlookup = rs.Fields(fld).Value<BR>    End If<BR>End Function<BR><BR>Dim UserID, iLength, UserName, ReqEmail, ReqName, ApprID, ApprName, CommentFld, ReqInfo<BR><BR>iLength = Len(Trim(Request.ServerVariables ("AUTH_USER"))) - instrrev(Trim(Request.ServerVariables ("AUTH_USER")),"\")<BR>UserID = Right(Trim(Request.ServerVariables ("AUTH_USER")), iLength)<BR>response.write "userid: "  &  userid & "<BR>"<BR>UserName =  xdirlookup(UserID,1)<BR>response.write "<BR>"<BR>response.write "username: " & username<BR>%&#062;<BR>