Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql sever 2005 linked server LDAP Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 10:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:11 PM
Points: 54, Visits: 1,270
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.
Post #1545480
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse