"Todd C" wrote:

> I am looking for a way to use our Win 2003 Active Directory as a DataSource
> in RS2005. I set up the Connection properties (correctly, I think) using OLE
> DB Provider for Microsoft Directory Services, and supplied the Server and
> Location (<myDomain.com>). The "Test Connection" responds with "Test
> connection succeeded", but it says that no matter what I put in for Location
> or Server.
>
> What is required here in these two boxes?
>
> After that, how do I write a SQL statement to query the Active Directory
> Data structure? DO I need OpenQuery statement? Can I write a SELECT statement
> directly?
>
> Another approach could be to set up a linked server using ADsDSOObject
> provider but I never got that to work either.
>
> Any help would be appreciated.
>
> Thanks in advance.
>