sql sever 2005 linked server LDAP

  • 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.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply