When I set up a linked server and create a view which references a table on
the linked server, all the operations like: insert, update, delete are
working well. But it will fail if I start execute a 'begin distributed tran'
clause prior of those view operations I have metioned above. The error
message I got is:
Server: Msg 7391, Level 16, State 1, Line 1
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
does not support distributed transactions.
[OLE/DB provider returned message: Distributed transaction error]
According to the SQL 7.0, the ole db provider should support the distibuted
Any helps are appreciated in advance.