BF
Thu Mar 09 09:42:50 CST 2006
I just checked MSDN for all members of TransactionScope at
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.NETDEVFX.v20.en/cpref12/html/T_System_Transactions_TransactionScope_Members.htm
There is no timeout property for TransactionScope.
And the error I get is "The transaction has already been implicitly or
explicitly committed or aborted".
I get this error after 1 minute 20 seconds of waiting.
So I believe there are some other settings or limitations causing this
error. The code is so simple. The database is on local area network. There
are must be some easy reason for this. Does TransactionSope support Windows
Authentication database connection?
Thanks a lot.
"Sahil Malik [MVP C#]" wrote:
> There is a 1 minute default transaction timeout on TransactionScope.
>
> SM
>
>
>
> "BF" <BF@discussions.microsoft.com> wrote in message
> news:C96D5EF2-4DDC-469F-B3E8-8FC189788D04@microsoft.com...
> > Actually, I don't think this is a timeout issue. I only open a connection
> > to
> > a database on local network. If you don't use TransactionScope, I can open
> > this connection in no time.
> >
> > But if I use TransactionScope, it wait and wait until time out. I think
> > this
> > problem is when I use TransactionScope, I cannot open database connection
> > at
> > all.
> >
> > Thanks a lot.
> >
> >
> > "Sahil Malik [MVP C#]" wrote:
> >
> >> TransactionScope based transactions have a default timeout of 1 minute -
> >> after which if you snooze for that long, it would have autorolled back.
> >> This
> >> is done to conserve resources from bad programmers.
> >>
> >> You can change the timeout using one of the constructors. :)
> >>
> >>
> >> --
> >> - Sahil Malik [MVP]
> >> ADO.NET 2.0 book -
> >>
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> >> ----------------------------------------------------------------------------
> >>
> >> "BF" <BF@discussions.microsoft.com> wrote in message
> >> news:CA6ACA66-D091-487D-862A-A28E08F5D021@microsoft.com...
> >> > This problem is so simple I am surprised it's happening.
> >> >
> >> > When I run the following code:
> >> >
> >> > using (TransactionScope ts = new TransactionScope())
> >> > {
> >> > SqlConnection conn = new SqlConnection(@"integrated
> >> > security=SSPI;data source=WSDEV\GODS;initial catalog=MOSES");
> >> > conn.Open();
> >> > }
> >> >
> >> > It waits at conn.Open(); for over 1 minute and return error message
> >> > "The
> >> > transaction has already been implicitly or explicitly committed or
> >> > aborted.".
> >> >
> >> > If I comment out TransactionScope line, it works without any problems.
> >> > So
> >> > the connection string is correct.
> >> >
> >> > Can anybody point out what's happening here?
> >> >
> >> > Thanks a lot.
> >> >
> >>
> >>
> >>
>
>
>