If after configuring your MS Distributed Transaction Coordinator (MSDTC) on the two SQL server’s according to the OP’s original post, you still get “no transaction active”, you should check that each host is reachable via
I saw the query in SQL profiler and run it in SQL, It works!
but when I try by visual studio it has error.
2