杭州交通信息网几何图形拼成的图案树:SQL与oracle数据的同步问题
来源：百度文库 编辑：杭州交通信息网 时间：2024/04/28 12:57:39
sql连接远程的oracle数据库(外网),用触发器实现同步,报错?请高手赐教!
本地的oracle 已连上外网的oracle 数据库,可以查询与写入.但是一用触发器就报下面的错误:
[microsoft][odbc sql server driver][sql server]the operation could not be performed because the ole db provider 'msdaora' does not support distributed transactions.
CREATE trigger t_test on dbo.test for insert,update,delete as
delete from srv_lnk..BUS.TEST where id in(select id from deleted)
insert into srv_lnk..BUS.TEST
select * from inserted
不好意思,就两分了啊!
本地的oracle 已连上外网的oracle 数据库,可以查询与写入.但是一用触发器就报下面的错误:
[microsoft][odbc sql server driver][sql server]the operation could not be performed because the ole db provider 'msdaora' does not support distributed transactions.
CREATE trigger t_test on dbo.test for insert,update,delete as
delete from srv_lnk..BUS.TEST where id in(select id from deleted)
insert into srv_lnk..BUS.TEST
select * from inserted
不好意思,就两分了啊!
887786655