Post reply

Error 7391 - The operation could not be performed because the OLE DB provider ''%ls'' was unable to begin a distributed transaction.

  • October 12, 2005 at 8:43 am

    #67054

    Hello

    We have a distributed database scheme setup with a "common" reference database and several customer databases setup. 

    Due to high transaction volume, last week we moved one of the customer databases to another server on a new machine.  The common database server is defined as a linked server.   Within the code and stored procedures all references to the "common" server were changed from "LookupDB.dbo.CodeTable" to CommonServer.LookupDB.dbo.CodeTable". 

    This works great for most queries, but when the application is running the .net code sets a transaction and the following Error 7391 - The operation could not be performed because the OLE DB provider '%ls' was unable to begin a distributed transaction.  Note: we are using Microsoft Drivers.

    The big issue is that the lookup tables are not even being changed, but only used as a reference in some of the stored procedures.  

    Anyone have any idea where to get another driver or a trick to get around the issue?

    Eric Peterson - ISTA

    (678) 361-9021

     

  • October 12, 2005 at 9:45 am

    #596850

    if the sql servers are based on windows 2003 servers, the errors come forth since windows 2003/xp security was added to microsoft transaction coordinator.

    See:

    http://support.microsoft.com/kb/839279

  • October 12, 2005 at 11:34 am

    #596895

    Thanks, this solves the problem.   http://support.microsoft.com/?kbid=839279

     

    Eric

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

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