Post reply

Programming and executing Jobs with Linked Server

  • May 2, 2008 at 4:06 pm

    #185081

    Hi guys, I have a problem with jobs, I'm trying to execute a job and returned to me an error saying 'MSDAORA' was unable to begin a distributed transaction', I had tested in one sql server 2000 against oracle server and the execution was successful, but in another sql server 2000 failed. Why can be this behaviour?

    Another question: A job generate an implicit transaction always? Because I'm trying to avoid the transaction putting the following statement SET IMPLICIT TRANSACTIONS OFF.

    Thanks in advance 😀

  • May 21, 2008 at 9:25 am

    #818656

    I have two servers, in one works but in the another server fails, both have the same service pack (SQL Server 2000 SP1, Windows Server 2003 SP1, and ths same oracle client (ora92). Any ideas!

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

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