cs_ghuysmans99
Messages postés3982Date d'inscriptionjeudi 14 juillet 2005StatutMembreDernière intervention30 juin 201316 17 janv. 2008 à 21:32
Dim
objConnection 'As Object (ADODB.Connection)
Dim objRecordSet 'As Object (ADODB.RecordSet)
Dim strConnectionString 'As String
Dim strSQL 'As String
Public Function OpenConn() As Boolean
CloseConn
Set objConnection = Server.CreateObject("ADODB.Connection")
strConnectionString = "Provider=ADSDSOObject;User ID=UserID;Password=Password;"
objConnection.ConnectionString = strConnectionString
On Error Resume Next
objConnection.Open
OpenConn = Not (Err)
Err.Clear
On Error GoTo 0
End Function<hr />
Public Sub CloseConn()
On Error Resume Next
objConnection.Close
Err.Clear
On Error GoTo 0
Set objConnection = Nothing
End Sub<hr />
Public Function ADTest() As Boolean
If Not (OpenConn) Then
Response.Write "Impossible de se connecter à Active Directory ...
"
ADTest = False
Exit Function
End If
strSQL = "SELECT ADsPath,samAccountName,memberOf FROM 'LDAP://.....' WHERE objectCategory='user' and samAccountName = 'toto'"
Set objRecordSet = objConnection.Execute(strSQL)
While Not (objRecordSet.EOF)
Response.Write "ADsPath=" & objRecordSet("ADsPath") & "
"
Response.Write "samAccountName=" & objRecordSet("samAccountName") & "
"
Response.Write "memberOf=" & objRecordSet("memberOf") & "
"
Response.Write "<HR SIZE=1 NOSHADE COLOR=""#FF0000"">
"
objRecordSet.MoveNext
Wend
'On ferme proprement l'objet recordset
objRecordSet.Close
'On atomise l'objet recordset
Set objRecordSet = Nothing
CloseConn
End Function<hr />,
----
Colorisation syntaxique par Renfield
Peut-être que ça marchera ...
_______________________________________________________________________
VB.NETis good ...VB6is better