Get AD Data via Sequel

20 Oct 2005 4:29 PM

Bahman

Hello!

Sorry if duplicate question:

Is there a way to get data from the AD via the sequel?

I would want things like 'name' and 'email' and 'phone'.

Off the topic of the fourm but: If not through sequel, how do I set up a
database connection to the AD directly for reporting purposes?

Thank you very much.

-Bahman

20 Oct 2005 4:38 PM

Jerry Spivey

Bahman,

You need to create a linkedserver definition for AD.

See:

OLE DB Provider for Microsoft Directory Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_94fn.asp

HTH

Jerry

Note: However ADSI might is probably easier and more functional.

Show quote

"Bahman" <Bah***@discussions.microsoft.com> wrote in message
news:ED01AA0F-691F-41C0-9BA2-8103A15212E7@microsoft.com...
> Hello!
>
> Sorry if duplicate question:
>
> Is there a way to get data from the AD via the sequel?
>
> I would want things like 'name' and 'email' and 'phone'.
>
> Off the topic of the fourm but: If not through sequel, how do I set up a
> database connection to the AD directly for reporting purposes?
>
> Thank you very much.
>
> -Bahman
>