ADO.NET and Active Directory

[Mario Rodriguez]

Hi people, there is a way to make searches on active directory thru
ADO.NET?, so the result is an DataSet object and not a DirectoryENtry object

thanks

 

[Paul Clement]

¤ Hi people, there is a way to make searches on active directory thru
¤ ADO.NET?, so the result is an DataSet object and not a DirectoryENtry object
¤

You can use the native .NET OLEDB library with the ADsDSOObject provider

Function QueryActiveDirectory() As Boolean

Dim ADConnection As New System.Data.OleDb.OleDbConnection("Provider=ADsDSOObject;")

ADConnection.Open()
Dim da As New System.Data.OleDb.OleDbDataAdapter("select name, ADsPath from
'LDAP://DC=xxx,DC=xxx,DC=org' WHERE objectCategory='organizationalUnit' or objectCategory='group'",
ADConnection)

Dim ds As New DataSet

da.Fill(ds, "ADResults")

frmMain.DataGrid1.SetDataBinding(ds, "ADResults")

ADConnection.Close()

End Function


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Marc Scheuner [MVP ADSI]]

Hi people, there is a way to make searches on active directory thru

ADO.NET?, so the result is an DataSet object and not a DirectoryENtry object

No, not out of the box. Also, in .NET, you can easily use the
DirectorySearcher class, which is quite easy and nice to use, really
(compared to the olden days of IDirectorySearch......)

Marc
================================================================
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch

 

[Mario Rodriguez]

DirectorySearcher returns an DirectoryEntry Collection or a DataSet ???

 

[Marc Scheuner [MVP ADSI]]

DirectorySearcher returns an DirectoryEntry Collection or a DataSet ???

It returns a DirectoryEntry on the .FindOne(), or a
SearchResultCollection in the .FindAll() methods. In both cases,
definitely *NOT* a data set.

MArc

================================================================
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch

 

[Paul Clement]

¤ >Hi people, there is a way to make searches on active directory thru
¤ >ADO.NET?, so the result is an DataSet object and not a DirectoryENtry object
¤
¤ No, not out of the box. Also, in .NET, you can easily use the
¤ DirectorySearcher class, which is quite easy and nice to use, really
¤ (compared to the olden days of IDirectorySearch......)

Well, actually you most certainly can query AD via ADO.NET (see the example in my post). The
ADsDSOObject provider is available to ADO.NET via the native .NET OLEDB library just as it was for
ADO and OLEDB.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)