Post reply

Active directory Problem

  • June 9, 2004 at 5:25 am

    #102054

    Hi,

    I have created a view over a test OU on our Active Directory server fine and my select queries all work ok. However when I try to perform an update query i get the following error message

    An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'.

    OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare:repare returned 0x80040e14].

    Does anybody know how to write update queries against a linked ADSI server.

    Cheers

    jay


    Truth is always Beauty but Beauty is not always Truth

  • June 10, 2004 at 7:02 am

    #509832

    My understanding is that connecting to linked AD (directly) only gives you select queries. No update, insert or deletes. I'm pretty sure that's what happened when I played with it.

    You can, however, use some AD RK tools from SQL Server by calling the utility (dsadd,...) using xp_cmdshell and passing it dynamic parameters. I'm sure you could write something yourself using VB and ADSI that'll do the same thing.

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

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