Results 1 to 3 of 3

Thread: generic connectivity, triggers

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    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

  2. #2
    Join Date
    Feb 2003
    Posts
    1,048
    What about setting up replication?

  3. #3
    Join Date
    Dec 2004
    Posts
    2
    how?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •