InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 20:15:29 GMT20http://www.sqlservercentral.com/Forums/Topic1244943-1042-1.aspxAnyone found a solution for this issue? I'm facing a similar/the same problem: I'm executing a SQL2008 stored procedure, which executes a SQL2005 stored procedure (via LINKED SERVER), which, in turn, executes a SELECT on an Oracle DB on a UNIX server (also via LINKED SERVER).I get the same error:{"The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.\rPR_PTT_GET_LOTTRACE_PRM, Msg 7391, Line 1: The operation could not be performed because OLE DB provider \"MSDAORA\" for linked server \"U03P\" was unable to begin a distributed transaction. ((null))\rTransaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0."}Any ideas?Fri, 13 Apr 2012 01:37:37 GMTwim 18116http://www.sqlservercentral.com/Forums/Topic1244943-1042-1.aspxCould you please let us know if you were able to solve the issue? and if so could you please mention how you did it? Thanks in advance!Wed, 22 Feb 2012 09:26:47 GMTIgnacio A. Salom Rangelhttp://www.sqlservercentral.com/Forums/Topic1244943-1042-1.aspxHi Gajanan.Verify that your network name resolution works. Verify that the servers can communicate with one another by name, not just by IP address. Check in both directions (for example, from server A to server B and from server B to server A). You must resolve all name resolution problems on the network before you run your distributed query. This may involve updating WINS, DNS, or LMHost files. i think helpful this below link.http://support.microsoft.com/kb/306212.http://support.microsoft.com/kb/922430Wed, 22 Feb 2012 02:41:51 GMTramprasad1485http://www.sqlservercentral.com/Forums/Topic1244943-1042-1.aspx[quote][b]gajananhatkar (2/1/2012)[/b][hr]OLE DB provider "OraOLEDB.Oracle" for linked server "ORAFINNONE" returned message "New transaction cannot enlist in the specified transaction coordinator. ".Msg 7391, Level 16, State 2, Line 1The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORAFINNONE" was unable to begin a distributed transaction.[/quote][url]http://support.microsoft.com/kb/887111[/url]Mon, 06 Feb 2012 06:47:58 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1244943-1042-1.aspxOLE DB provider "OraOLEDB.Oracle" for linked server "ORAFINNONE" returned message "New transaction cannot enlist in the specified transaction coordinator. ".Msg 7391, Level 16, State 2, Line 1The operation could not be performed because OLE DB provider "OraOLEDB.Oracle" for linked server "ORAFINNONE" was unable to begin a distributed transaction.Wed, 01 Feb 2012 03:31:07 GMTgajananhatkar