Post
Ask Question
taner gurel

taner gurel

  • NA
  • 1
  • 0

TableAdapters And TransactionScope

Sep 22 2007 4:56 AM

Hi i have a problem about transactionscope when i tried to use in a transactionscope two tableadapter updates than I have an error about MSDTC and always the error is in the second tableadapters connection.open clouse.I tried to do the settings of the MSDTC but I'm not sure that I was succeeded.It's ok on local but when I try to connect to the server this happens.I'm using VS2005 and on the server SQL Server 2005.

My code is like that

TransactionOptions options = new TransactionOptions();

options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;

options.Timeout = new TimeSpan(0, 2, 0);

using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))

{

TableAdapter1 TA1=new TableAdapter1();

TableAdapter2 TA2=new TableAdapter2();

TA1.Update();

TA2.Update();   /* I always have this error 'connection.open'  in the second one if I change the places of TA1 and TA2  then the error is in TA1*/

scope.Complete();

}

 

Thanks for helping...