http://forums.asp.net/54.aspxAll about SQL Server, SQL Server Express, MSDE, and the SqlDataSource control.enCommunityServer 2007 SP1 (Build: 20510.895)http://forums.asp.net/thread/2499763.aspxFri, 18 Jul 2008 19:11:16 GMT4c671506-2930-414c-a40b-8bf57ded5924:2499763mcook780http://forums.asp.net/thread/2499763.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=54&PostID=2499763<p>I was about to ask you if you ever figured this out because I&#39;m having the same problem today.&nbsp; Thankfully my genious architect friend turned me on to connection pooling and sure enough that was my problem.&nbsp; I turned connection pooling off &quot;Pooling=false&quot; in the connection string and now everything works.&nbsp; I suppose&nbsp;another option would be to use a separate connection string.</p> <p>&nbsp;Matt</p>http://forums.asp.net/thread/2360457.aspxThu, 15 May 2008 16:43:27 GMT4c671506-2930-414c-a40b-8bf57ded5924:2360457ankem0http://forums.asp.net/thread/2360457.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=54&PostID=2360457Hello, I&#39;ve a problem with a software developed in C# with the framework 2.0. This is the error I receive : The operation could not be performed because OLE DB provider &quot;SQLNCLI&quot; for linked server &quot;XXX_LINKED_SERVER&quot; was unable to begin a distributed transaction. OLE DB provider &quot;SQLNCLI&quot; for linked server &quot;XXX_LINKED_SERVER&quot; returned message &quot;No transaction is active.&quot;. If I try directly to restart the process, it works fine. Is there someone who can help me ? This is the process 1. In C# --&gt; Call of a Query : select from the linked server (db in sql 2005) and insert into a table SQL 2005 2. In the C# --&gt; using (TransactionScope scope = new TransactionScope()) and insert in a table in SQL 2005 which is link server Thank in advance.