SQL分布计算时出现问题?
我想Select WEB服务器上的数据插入到我本地的SQL服务器(我的WEB数据库是在外面托管主机上,而我内部通过拔号上网,并且本地数据库已经通过 Linket Servers正常连结到外部的服务器)
当在本地执行执行下面的存储过程时出现:
CREATE Procedure u_Dtc_out
/*
测试DTC
*/
As
Set nocount on
Begin distributed tran testDtc
insert into tabLocTest values('OK')
exec [202.103.134.239].zx..proTest
if @@error > 0
rollback tran
else
Commit tran
return
当我执行时出现:
Server: Msg 7391, Level 16, State 1, Procedure u_Dtc_out, Line 12
The operation could not be performed because the OLE DB provider 'SQLOLEDB' does not support distributed transactions.
[OLE/DB provider returned message: 分布事务处理错误]
为什么?