22,300
社区成员
发帖
与我相关
我的任务
分享紧急求助!链接服务更新问题,我要完了
紧急求助!链接服务更新问题,我要完了
本人用链接服务方式更新另一台服务器的数据
直接在查询分析器中执行如下:
update manager01.erp_universal.dbo.part set description='test' where id='1111'
可以成功
但如果加上事务执行
------------------
begin tran
update manager01.erp_universal.dbo.part set description='test' where id='1111'
commit
-------------------
就出现如下错误:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
因为是在程序里更新,自动会加上事务
真的找不到原因了,请各位高手帮我解决啊
急,在线等,谢谢,谢谢
本人用链接服务方式更新另一台服务器的数据
直接在查询分析器中执行如下:
update manager01.erp_universal.dbo.part set description='test' where id='1111'
可以成功
但如果加上事务执行
------------------
begin tran
update manager01.erp_universal.dbo.part set description='test' where id='1111'
commit
-------------------
就出现如下错误:
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.
[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].
因为是在程序里更新,自动会加上事务
真的找不到原因了,请各位高手帮我解决啊
急,在线等,谢谢,谢谢
...全文
请发表友善的回复…
发表回复
qingsongy 2006-07-21
- 打赏
- 举报
--- net start msdtc on both machines.
--- if you installed XP SP2, disable firewall on both machines.
--- configure msdtc on both machines
http://support.microsoft.com/kb/839279/
--- if you installed XP SP2, disable firewall on both machines.
--- configure msdtc on both machines
http://support.microsoft.com/kb/839279/
chyliu 2006-07-20
- 打赏
- 举报
怎么没有回答啊，不够可以加分啊
实在是急
实在是急
xqlzh 2006-07-20
- 打赏
- 举报
我也有同样的问题，并且我按以下的步骤设置了MS DTC服务也还是不行！
1. Click Start, point to All Programs, point to Administrative Tools, and click Component Services.
2. In the Component Services console, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
3. In the My Computer Properties dialog box, on the MSDTC tab, click Security Configuration.
4. In the Security Configuration dialog box, select the Network DTC Access check box, select the Network Administration check box, select the Network Transactions check box, select the Network Clients check box, select the Transaction Internet Protocol (TIP) Transaction check box, and then click OK.
5. Restart the computer.
）。
给出一些关于该问题的一些资料连接：
对链接的服务器运行分布式事务处理时出现错误 7391
http://support.microsoft.com/?scid=kb;zh-cn;329332&spid=2852&sid=318
SQL Server DT问与答
http://www.cnxuexi.com/computer/chengxusheji/shujuku/4373.html
windows server 2003 中 SQL Server 2000 分布式事务 错误解决方法
http://baist.net/Article/ASPtech/200606/Article_4907.shtml
分布式查询
http://blog.csdn.net/sxycgxj/archive/2006/05/20/746346.aspx
1. Click Start, point to All Programs, point to Administrative Tools, and click Component Services.
2. In the Component Services console, expand Component Services, expand Computers, right-click My Computer, and then click Properties.
3. In the My Computer Properties dialog box, on the MSDTC tab, click Security Configuration.
4. In the Security Configuration dialog box, select the Network DTC Access check box, select the Network Administration check box, select the Network Transactions check box, select the Network Clients check box, select the Transaction Internet Protocol (TIP) Transaction check box, and then click OK.
5. Restart the computer.
）。
给出一些关于该问题的一些资料连接：
对链接的服务器运行分布式事务处理时出现错误 7391
http://support.microsoft.com/?scid=kb;zh-cn;329332&spid=2852&sid=318
SQL Server DT问与答
http://www.cnxuexi.com/computer/chengxusheji/shujuku/4373.html
windows server 2003 中 SQL Server 2000 分布式事务 错误解决方法
http://baist.net/Article/ASPtech/200606/Article_4907.shtml
分布式查询
http://blog.csdn.net/sxycgxj/archive/2006/05/20/746346.aspx
