Active Directory Query?
MikeDotNet
Posts: 2
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
[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
This discussion has been closed.
Comments
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.