Receive Data from Oracle Internet Directory

Question

Hi all...

I have to create a view that shows data from a OID (Oracle Internet Directory).

I created a linked server, that uses "OLE DB Provider for Microsoft Directory Services" and tried to query by LDAP. But it does not work. 

Anyone with experience? 

Thanks

Answer 1

Are you sure that user has the correct access rights to Oracle?

---

MCP, MCTS, MCITP

Answer 2

Are you sure that user has the correct access rights to Oracle?

I can login with these credentials to OID with a LDAP Browser.

This is what I have to use as value for the user name: cn=clientele_dev_01,cn=tech_users,cn=dev_env,o=******,c=ch
I guess that OID can't handle the credentials if I'm using the ADsDSOObject to connect. ... I dont't know.

I tried for days to find a working solution. I would like to know if anyone ever accomplished to read data from OID into a view.

Tis

Answer 3

Hi Tis000,

The Microsoft OLE DB Provider for Microsoft Directory Services provides access to information in the Microsoft Windows 2000 Directory Service. The maximum number of objects that can be returned by a query using this provider is 1000.

For connecting Oracle Internet Directory, I don’t think it is supported by this provider. One workaround is move the data from OID to local database and create linked server from SQL Server to oracle using Microsoft OLE DB Provider for Oracle or Microsoft ODBC Driver for Oracle.

Suggest you to submit a feedback to Microsoft for this issue. For submitting a feedback to Microsoft such issues, I would recommend to submit it to the Microsoft Connect at this link https://connect.microsoft.com/SQLServer/Feedback. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.

Thanks for your understanding and support.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.