How can we help you today? How can we help you today?

Active Directory Query?

I have a view that queries Active Directory using a Linked Server on SQL Server 2000. When attempting to synchronize it i get the following error:
[7390] The requested operation could not be performed because the OLE DB provider 'ADSDSOObject' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' IUnknown::QueryInterface returned 0x80004002].

It's not that big of a deal to me since I only have this one view and I update it manually, but just wanted to throw that out that on the off-chance anything can be done to resolve this.

Thanks,
Mike
MikeDotNet
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi Mike,

    This can happen with linked servers because the driver behind the linked server doesn't support the same isolation level as SQL Server does natively. If you save the script, then change the line

    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

    to

    SET TRANSACTION ISOLATION LEVEL READ COMMITTED

    then the script will probably run.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.