Post reply

Querying Active Directory

  • July 3, 2003 at 8:35 am

    #59072

    I have a couple of questions for anyone willing to take a stab at it.

    One, when I try to click on Tables or Views from EM for my linked server to ADSI, I get the following error:

    Error 7301: Could not obtain a required interface from OLE DB provider 'ADSDSOObject'

    Does anyone know why I am getting this, what it means, and how I can correct it?

    Two, I am trying to find some information on the syntax needed to query AD. All of the examples I am finding on the web are all very simple and use the same examples (very basic ones). Does anyone know where I can find more information about querying AD from SQL Server?

    Thanks in advance.

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

  • July 3, 2003 at 10:06 am

    #464089

    1. Sounds like some "driver" type or unregistered COM interface issue. Can you query AD from VBScript on that machine? I'd be sure you can do this first.

    2. The querying you will do from SQL will be the same type of COM querying you do from any other interface. If you want to do it from within T-SQL, look up sp_oacreate_object.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net

  • July 4, 2003 at 3:07 am

    #464169

    I get the same message however I am still able to get AD info into a view or table only if I create the linked server with an NT logon not a SQL logon. Use sp_addlinkedsrvlogin.

    I would also like to know though why the error occurs

    The ONLY place to find the user interface mappings is here

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/netdir/ad/user_object_user_interface_mapping.asp

    HTH

Viewing 3 posts - 1 through 2 (of 2 total)

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