SQL Server Performance Forum – Threads Archive

query via ldap

Hi, I’ve got a "phone-book-application" with a ldap interface (only).
I just want to pass the names and phone nr. from my Sql-Server to this application. Is there a way to query Sql-Server via ldap?

---

http://www.4guysfromrolla.com/webtech/041800-1.shtml see this helps. Further using OLEDB driver for LDAP should work fine with linked server. If you are connecting to a MS Active directory, you can use ADsDSOObject. Here is an post that come from another forum http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=300083&SiteID=1 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

Thanks for your answer,
but the link you provided did not answer my question.
The article explains how to connect to Ad via ldap using ado,
but I want sql-server to answer to a ldap query. The solution I need should answer a ldap query from the "phone-book-application" (directly or indirectly) with data stored in the Sql-Server.

---

Querying SQL through LDAP is doing things backwards, as far as I can tell. You would use ADO to interface with the LDAP service, and you would also use ADO to interface with SQL Server, and you could use ADO to interface between the LDAP service and SQL Server. You can probably configure an external data sources within the LDAP application pointing to SQL Server, after which you could query LDAP, which would in turn query SQL Server.

---

]]>