-
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
-
What about setting up replication?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|