UC知道关于ASP对AD帐号操作的问题
来源：百度知道 编辑：UC知道 时间：2024/06/06 23:41:12
<%
Const ADS_SCOPE_SUBTREE = 1
Set objConnection = CreateObject("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")
objConnection.Provider = "ADsDSOObject"
objConnection.Open "Active Directory Provider"
Set objCommand.ActiveConnection = objConnection
objCommand.Properties("Page Size") = 9999
objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
objCommand.CommandText = "SELECT Name,Title,Department,telephoneNumber,mail,distinguishedName,sAMAccountName,l,wWWHomePage FROM 'LDAP://ou=tt,dc=test,dc=com' where objectCategory='user'"
Set objRecordSet = objCommand.Execute
%>
上面的代码可以查询AD帐号的信息,我想改变SELECT语句使它可以修改域用户的信息不知道是否可以? 应该用哪条语句!
比如:把 objCommand.CommandText = "SELECT Name,Title,Department,telephoneNumber,mail,distinguishedName,sAMAccountName,l,wWWHomePage FROM 'LDAP://ou=tt,dc=test,dc=com'
Const ADS_SCOPE_SUBTREE = 1
Set objConnection = CreateObject("ADODB.Connection")
Set objCommand = CreateObject("ADODB.Command")
objConnection.Provider = "ADsDSOObject"
objConnection.Open "Active Directory Provider"
Set objCommand.ActiveConnection = objConnection
objCommand.Properties("Page Size") = 9999
objCommand.Properties("Searchscope") = ADS_SCOPE_SUBTREE
objCommand.CommandText = "SELECT Name,Title,Department,telephoneNumber,mail,distinguishedName,sAMAccountName,l,wWWHomePage FROM 'LDAP://ou=tt,dc=test,dc=com' where objectCategory='user'"
Set objRecordSet = objCommand.Execute
%>
上面的代码可以查询AD帐号的信息,我想改变SELECT语句使它可以修改域用户的信息不知道是否可以? 应该用哪条语句!
比如:把 objCommand.CommandText = "SELECT Name,Title,Department,telephoneNumber,mail,distinguishedName,sAMAccountName,l,wWWHomePage FROM 'LDAP://ou=tt,dc=test,dc=com'
objCommand.CommandText ="update 'LDAP://ou=tt,dc=test,dc=com' set Name='11',Title='111',Department='11' where objectCategory='user'"
自段可以再加.不知道是不是这种效果?
出错的话..那是LDAP连接有问题。或者写错。
LDAP 没用过。
'LDAP://ou=tt,dc=test,dc=com' 这里换一个表名,就不会出错