I'm trying to synchronize 2 databases via a linked server from a SQL SERVER 2000 sp4 in Microsoft Server 2003 r2 sp2 to Postgresql8.4.7 in ubuntu 10, and by interface of SQLserver work perfectly, the problem is I need that when an insert is performed on the database A to automatically update the database B.
This function is performed via triggers, the problem is that if I put the query of the linkedserver in the trigger gives me the following error:
Server: Msg 8522, Level 18, State 1, Line 1
Distributed transaction aborted by MSDTC.
The MSDTC service is enabled with all the options allowed.
the query is like:
INSERT INTO OPENQUERY (OPEN_LINK, 'select q_sent, op1 from table1') select 'text', 'new';
We also tested
insert into [OPEN_LINK]...table1 (q_sent, op1) values ('text', 'new');
Any idea plz?