Trying to run a Distributed transaction (uses MSDTC) using a linked server between SQL 7 servers.
It uses OLEDB to support the connection - when I run the tran, it comes back with error
message saying "SQLOLEDB does not support Distributed transactions". All documentation suggests this
should work. Will be infinitely grateful for any suggestions!