Post reply

problem starting a distributed transaction on oracle from sql server

  • May 19, 2005 at 6:30 am

    #164626

    begin distributed transaction

    insert into openrowset('MSDAORA','SMPTEST';'scott';'tiger','select * from dept')   select  '56','OFFICER','DELHI' From owner

    commit transaction

    Server: Msg 7391, Level 16, State 1, Line 3

    The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction.

    OLE DB error trace [OLE/DB Provider 'MSDAORA' ITransactionJoin::JoinTransaction returned 0x8004d01b].

  • May 23, 2005 at 4:11 pm

    #560629

    What is the Server OS?

  • May 24, 2005 at 12:21 am

    #560660

    server os in windows 2000 server

  • May 24, 2005 at 6:43 am

    #560731

    Hello Jaydeep,

    Its just a guess because I never done such a setup but maybe you could look at the:

    Oracle Service for MTS

    Is it installed and running?

    Hope it can help,

    Regards,

    Carl

  • November 21, 2005 at 3:33 am

    #604888

    Oracle Service for MTS??? *chuckles*

    I'm having a similar issue. Also trying to get around it by executing a procedure on the Oracle database and passing parameters, but that errors, too.

    I think the biggest issue is that the OLE DB drivers for Oracle don't present any real error description, so you're never sure where to look to resolve it.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply