Results 1 to 5 of 5

Thread: DB Link with HS / OleDB for MS SQL

  1. #1
    Join Date
    Sep 2003
    Location
    Salvador-BA, Brasil
    Posts
    9

    DB Link with HS / OleDB for MS SQL

    Hello Group:

    I have a DB link using HS OLEDB for MS-SQL Server. Now, I want to do a distributed transaction between Oracle and SQL Server, but the DB Link returns an error: ORA-02047 Cannot Join the Distributed Transaction in Progress....

    Can any one help me ?

    Thank you.

    Aldair.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Is the transaction initiated in sql server? If yes, then did you issue

    SET XACT_ABORT ON
    BEGIN DISTIBUTED TRANSACTION

  3. #3
    Join Date
    Sep 2003
    Location
    Salvador-BA, Brasil
    Posts
    9
    Thank you for your attention !

    But my distributed transaction is initiate at the Oracle side and use a Oracle´s DataBase link.

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have to use Transparent Gateway for MS SQL Server to be able to initiate a distributed transaction from Oracle.

    Generic Heterogeneous Connectivity does not allow it.

  5. #5
    Join Date
    Sep 2003
    Location
    Salvador-BA, Brasil
    Posts
    9
    Thank you for your help.

    If the Oracle Tranparent GateWay is the only way, I will use another method !

    Thank you.

    Aldair.

Posting Permissions

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