Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    31

    Unhappy Unanswered: Distributed Transaction

    I am trying to access a table in another server and I keep getting this error msg.

    'THE OLEDB provider was unable to begin a distributed transaction'

    I have a linked server and I am using Microsoft OLE DB Provider for SQL Server.

    Anyone can help?

  2. #2
    Join Date
    Oct 2003
    Posts
    7
    can you give an example as to the way you are trying to access the other table on the 'b' server?

    What T-SQL statement are you trying to use?

  3. #3
    Join Date
    Nov 2003
    Posts
    31

    Red face

    I was trying to INSERT. Does that only work for SELECT?!

  4. #4
    Join Date
    Nov 2003
    Posts
    31
    Basically i was trying to use the statement below where AP2K380 is my linked Server.

    insert into AP2K380.asiapac702_test.dbo.tblCustServiceHistoryH dr

    and I ran into an error saying that the SQLOLEDB was unable to being a distributed transaction.

    Pls help...thanks a million!

Posting Permissions

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