Tis (8/2/2012)
... tried to query by LDAP. But it does not work.
Would you mind in defining "does not work"?
OID is supported by an Oracle database therefore a SQL Server side linked server pointing to the underlying Oracle database - provided the connection presents itself with the right credentials, should suffice to provide the needed access.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.