MikeBronner
Programmer
Could someone post an example of ASP code used to query LDAP without any proprietary components?
Thanks! Take Care,
Mike
Thanks! Take Care,
Mike
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Example of ASP LDAP query string? 14
- Thread starter MikeBronner
- Start date
- Status
I can connect with no problems...it's only certain attributes like department and memberOf that hose things up.
I can return cn, mail, description, sn, ect. but there are some that return "Unspecified Error" when I include them in the query. I tried using both LDAP and GC...same result. I did find that GC is quicker though.
I can return cn, mail, description, sn, ect. but there are some that return "Unspecified Error" when I include them in the query. I tried using both LDAP and GC...same result. I did find that GC is quicker though.
ZColton, I hope theres still a chance you may read this.
Back in Oct 14, 2003 you posted a script having listed the departments with a "distinct" option so as to not list every dept 100 times. I've been trying to do that for a week now and going nutz... the script you posted worked excellent, only I need to do that in a drop down list. I've been working with your script trying to make it work and I give up and turning to you for help.
Thanks
CN
Back in Oct 14, 2003 you posted a script having listed the departments with a "distinct" option so as to not list every dept 100 times. I've been trying to do that for a week now and going nutz... the script you posted worked excellent, only I need to do that in a drop down list. I've been working with your script trying to make it work and I give up and turning to you for help.
Thanks
CN
All Done:
Code:
<%@ Language=VBScript %>
<%
Option Explicit
response.buffer = true
Dim con,rs,Com,objADsPath,objDomain,objADOU,iLoop,bolFound,strdepartments,rsarray,rowcounter,numrows
strdepartments=""
%>
<html>
<head>
<title>Phone List</title>
</head>
<body bgcolor="#CCCCCC" topmargin="0" leftmargin="0">
<%
Set objDomain = GetObject ("GC://rootDSE")
objADsPath = objDomain.Get("defaultNamingContext")
Set objDomain = Nothing
Set con = Server.CreateObject("ADODB.Connection")
con.provider ="ADsDSOObject"
con.open "Active Directory Provider"
Set Com = CreateObject("ADODB.Command")
Set Com.ActiveConnection = con
Com.CommandText ="select department from 'GC://"+objADsPath+"' WHERE objectCategory='person' AND department='*' ORDER BY department"
Set rs = Com.Execute
rsarray=rs.getrows
rs.Close
con.close
Set rs = Nothing
Set con = Nothing
numrows=ubound(rsarray,2)
FOR rowcounter=0 to numrows
dim myarray
myarray=split(strdepartments,",")
bolFound = False
For iLoop = LBound(myarray) to UBound(myarray)
If CStr(myarray(iLoop)) = CStr(rsarray(0,rowcounter)) Then
bolFound = True
End If
Next
IF bolFound = False Then
If strdepartments="" then
strdepartments=rsarray(0,rowcounter)
Else
strdepartments=strdepartments&","&rsarray(0,rowcounter)
End If
End If
NEXT
dim deparray
deparray=split(strdepartments,",")
%>
<form>
<p><select size="1" name="department">
<option selected>Select a Department</option>
<%For iLoop = LBound(deparray) to UBound(deparray)%>
<option><%response.write deparray(iLoop)%></option>
<%Next%>
</select></p>
</form>
</body>
</html>Hi,
Im very new at asp and LDAP.
My scenario: A user opens an .asp page and some fields get populated with thier information taken from exchange server.
What im doing:
I know how to get a logon name of the local user.
1 - Im trying to search for LDAP servers on my network.
Then select the correct LDAP server (exchange server?)
2 - then in the server use the logon name to get the object that contains the attibutes of the logon user.
populating the field i know but i dont know how to do the LDAP stuff.
Can anyone help?
Im very new at asp and LDAP.
My scenario: A user opens an .asp page and some fields get populated with thier information taken from exchange server.
What im doing:
I know how to get a logon name of the local user.
1 - Im trying to search for LDAP servers on my network.
Then select the correct LDAP server (exchange server?)
2 - then in the server use the logon name to get the object that contains the attibutes of the logon user.
populating the field i know but i dont know how to do the LDAP stuff.
Can anyone help?
oh sorry i forgot
yeah win2k and exchange 2k.
im currently trying to test out your phonebook example.
im looking at the code whre u dont have to hard code the server name.
Is is possible to do that example using LDAP?
Also im not familiar with what objects in exchange 2k has the attributes of the users
Thanks for your help.
yeah win2k and exchange 2k.
im currently trying to test out your phonebook example.
im looking at the code whre u dont have to hard code the server name.
Is is possible to do that example using LDAP?
Also im not familiar with what objects in exchange 2k has the attributes of the users
Thanks for your help.
I was also looking at this page.
i could piece together the code with no hard coding (GC) and the object ideas together and possibly make a solution
but i have no concrete idea on how to do this
i could piece together the code with no hard coding (GC) and the object ideas together and possibly make a solution
but i have no concrete idea on how to do this
On my asp form i want to populate; user real name, phone extention, email address into separate text fields.
So when the user accesses this page it will automatically fill in those information. This asp page is part of our service desk request form.
i could post my form if you would like to see it
So when the user accesses this page it will automatically fill in those information. This asp page is part of our service desk request form.
i could post my form if you would like to see it
All done:
Code:
<%@ Language=VBScript %>
<%
Option Explicit
Dim strUsername,con,rs,Com,objADsPath,objDomain,name,telephonenumber,mail
%>
<html>
<head>
</head>
<body>
<%
strUsername = Request.ServerVariables("auth_user")
strUserName = Right(strUserName, Len(strUserName) - InStrRev(strUserName, "\"))
Set objDomain = GetObject ("GC://rootDSE")
objADsPath = objDomain.Get("defaultNamingContext")
Set objDomain = Nothing
Set con = Server.CreateObject("ADODB.Connection")
con.provider ="ADsDSOObject"
con.open "Active Directory Provider"
Set Com = CreateObject("ADODB.Command")
Set Com.ActiveConnection = con
Com.CommandText ="select name,telephonenumber,mail FROM 'GC://"+objADsPath+"' where sAMAccountname='"+strUsername+"'"
Set rs = Com.Execute
name=rs("name")
telephonenumber=rs("telephonenumber")
mail=rs("mail")
rs.Close
con.Close
Set rs = Nothing
Set con = Nothing
response.write name&"<br>"
response.write telephonenumber&"<br>"
response.write mail&"<br>"
%>
</body>
</html>
- Status
Similar threads
- Locked
- Question
- Locked
- Question