I have LDAP linked server on sql server 2005. When I expand tables/views node under the linked server, I got the following error message,
Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "ADSDSOObject" for linked server "ADSI2". (Microsoft SQL Server, Error: 7301)
But when I following query, I am able to get the result.
Select top 10 * FROM OPENQUERY(ADSI2,
'SELECT cn FROM ''LDAP://shslawapp.shorehealth.org/OU=resources,O=lwsnrmdata,CN=lawson,DC=lawprod'' ')
Thank you in advance.