How do I populate Active Directory user account information into Sharepoint?

Greetings,

I am working on implementing a phone directory for our organization into Sharepoint Services. I created the web page based around the example provided at this URL - and when I connect to the Northwind database, it works great.

http://www.intranetjournal.com/articles/200504/ij_04_06_05a.html

Next, I created a SQL view in a database called AD_Search. This is based on several examples discovered on the web. The view is titled, "vw_AD_USER_INFO". I've taken out our domain out of the LDAP portion of the view.

SELECT     givenName, sn, telephoneNumber
FROM         OPENQUERY(ADSI,
                      'SELECT title, displayName, sAMAccountName, givenName, telephoneNumber, sn FROM ''LDAP://DC=****'' where objectClass = ''User''')
                      Rowset_1

If I return all rows, I am able to see the users first and last name and extension so I know the view is working OK. Where I run into the error is at this point:

When I open the PhoneSearch page, and go to create a Data Source in FrontPage and select that SQL view, "vw_AD_USER_INFO", it does not allow me to select Fields in the Query section. That is when I get the error that states, "Server Error: The server for the data source returned a non-specific error when trying to execute your query. Check the format and content of your query and try again."

I am out of ideas on what to check and/or do next. Any suggestions would be much appreciated.

Thanks!

Start Free Trial