EDN Admin
Well-known member
Please let me know if there is a more appropriate forum for this issue.
I have a classic ASP web application where we are attempting to use ADO 2.5 and theADsDSOObject provider to validate users in an OpenLDAP (non-active directory) system. I have been trying various examples found from web searches, but nothing appears to work. This is in IIS 6, on Windows Server 2003. Regardless of the syntax of the LDAP filter or DN, the error returned by the connection Execute method is always "Table does not exist".
One of my primary questions is regarding the user ID/pw used to initiate the ado connection. Does ADO need an admin/domain admin user in order to open the connection?
The server-side vbScript is:----------------------------------------------------------------------
strUser and strPwd: The user ID and password of the person attempting to log in.
Q: Does the user ID and password used to initiate the connection need to be domain admin, on MS Win server 2003?
Have been attempting to specify attributes in the query:
;displayName,mail;SubTree
;Name;SubTree
Set oConn = CreateObject("ADODB.Connection")
Set oRS = CreateObject("ADODB.Recordset")
Call oConn.Open("Data Source=Active Directory Provider;Provider=ADsDSOObject;User ID=" & _
strUser & ";password=" & strPwd & ";")
strHost = "{address
ort of host}"
strDN = "ou=Users,o={orgnamedomain},c=US"
strQry = "<LDAP://" & strHost & "/" & strDN & ";" & _
"(uid=" & strUser & "*);displayName;SubTree"
Set oRS = oConn.Execute(strQry)
----------------------------------------------------------------------
Thank you for any help or direction.
Brian Wieczorek
View the full article
I have a classic ASP web application where we are attempting to use ADO 2.5 and theADsDSOObject provider to validate users in an OpenLDAP (non-active directory) system. I have been trying various examples found from web searches, but nothing appears to work. This is in IIS 6, on Windows Server 2003. Regardless of the syntax of the LDAP filter or DN, the error returned by the connection Execute method is always "Table does not exist".
One of my primary questions is regarding the user ID/pw used to initiate the ado connection. Does ADO need an admin/domain admin user in order to open the connection?
The server-side vbScript is:----------------------------------------------------------------------
strUser and strPwd: The user ID and password of the person attempting to log in.
Q: Does the user ID and password used to initiate the connection need to be domain admin, on MS Win server 2003?
Have been attempting to specify attributes in the query:
;displayName,mail;SubTree
;Name;SubTree
Set oConn = CreateObject("ADODB.Connection")
Set oRS = CreateObject("ADODB.Recordset")
Call oConn.Open("Data Source=Active Directory Provider;Provider=ADsDSOObject;User ID=" & _
strUser & ";password=" & strPwd & ";")
strHost = "{address
ort of host}"strDN = "ou=Users,o={orgnamedomain},c=US"
strQry = "<LDAP://" & strHost & "/" & strDN & ";" & _
"(uid=" & strUser & "*);displayName;SubTree"
Set oRS = oConn.Execute(strQry)
----------------------------------------------------------------------
Thank you for any help or direction.
Brian Wieczorek
View the full article
