generic connectivity, triggers
in order to replicate from oracle to sql-server i made a generic conecctivity using ODBC. I create a databse link to sqlserver and in SQL Plus i can access to sqlserver table and i can modify it by inserting updating or deleting.
But the problem comes when i want to make that with a trigger, when i try to update the table then i get this error ORA-02047: cannot join the distributed transaction in progress.
Is this posible? or what can i do to replicate tables from oracle to sqlserver
Thanks for your time