请教一个分布式事物问题!

[jerry3619605]

Begin distributed tran processCallInfo_236

insert into agent..out2
(callType,callOutStartTime,callAnsweredTime,callDropedTime,callReleasedTime,call outstatus,callCallerCode,callCalledCode,callRecordFileId,bRecord,userdtmf,trkdtmf)
select
'outbound',callstarttime,callanswerTime,calldroptime,callendtime,calloutstatus,
callcallercode,callcalledcode,wavfile,(recordstatus+1),userdtmf,trkdtmf
from SRV_236.QCALL.dbo.callinfo_local where isProcessed = 0


update SRV_236.QCALL.dbo.callinfo_local set isProcessed = 1 where isProcessed=0
if @@ERROR <> 0
Begin
ROLLBACK transaction processCallInfo_236
PRINT '更新236 allInfo数据失败'
End
Commit transaction processCallInfo_236


里面的程序正常运行,可是加了Begin distributed tran 之后就不能执行了.也不报错,就是死在那了!!!!!!!!!!!!!!!

[whbjob]

我也遇到类似的问题，似乎分布式事物的执行需要操作系统间有信任关系，可以尝试在局域网执行

[junmail]

不懂，帮顶！

[LANTE80]

不懂，帮顶！关注