Linked server issue

From: Mark D (D_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 12:51:03 -0700

Our linked server on our test system suddenly started acting strangely
yesterday afternoon. We get error the 7391 error when inserting/modifying
data from a query that includes a joined table from another sql server. The
rest of the error is below:
"The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to begin a distributed transaction.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransactoin returned 0x8004d00a."

I am able to work around the error by inserting into a temp table, then
inserting the temp table into the permanent table or modifying the permanent
table.

Does anyone have any ideas? (I have verified that both servers have the DTC
running and they are configured properly.)

Relevant Pages

  • Re: ssh and kerberos
    ... Your ssh_config file on both client and server ... Workaround: inserting the following in ... # How often to rotate kdc.log. ...
    (comp.unix.solaris)
  • Re: SELECT * FROM INTO
    ... temp tables. ... The only way to put data in to permanent tables is to ... This isn't currently supported in even the latest version of Informix Dynamic ... Server, but is in Extended Parallel Server. ...
    (comp.databases.informix)
  • Re: No Data After DataAdapter Update
    ... If all you are doing is inserting, ... Before you pass the dataset back to the adapter, ... You don't have to load the data from the server in order to use a data ... The data being transferred into the POI_Entity DataTable is from two XML ...
    (microsoft.public.dotnet.languages.csharp)
  • Batch/Block-Mode updates to Select Lists - How to avoid?
    ... ONevent/function I am retrieving all these lovely rows from the server and ... (The on screen appearance of the Select ... The problem is that none of the rows I'm inserting appear on the screen ...
    (comp.lang.javascript)
  • Re: Runtime Error ! R6025
    ... not dead. ... Well my toolbox and templates are on a server, so because I was losing the ... Do you get the error when inserting the part or adding a mate to the part? ... Have you cleaned up your temp folder? ...
    (comp.cad.solidworks)