[Mono-bugs] [Bug 381151] DataAdapter returns 0 rows after an SQL timeout occured

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=381151

User mark at dawebber.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=381151#c16





--- Comment #16 from Mark Gimelfarb <mark at dawebber.com>  2008-04-24 21:19:56 MST ---
@Veerapuram:
Yes, I still the same indefinite wait despite the 5 seconds CommandTimeout
setting.  If you wait more than CommandTimeout from what I understand (and the
way MS.NET works), you should be getting TdsTimeoutException, bubbling up as
SqlException: Timeout Exception. I agree with Gert--from the looks of it, the
SqlConnection is hosed at that time (at least on the physical level, and the
Connection Pool is not aware of it).

I don't understand while we are not getting the same results between mine and
your test. What version/SP level of SQL server are you testing against?

Would you like an SSH session into my box? We can probably arrange that.

What else can I provide to help troubleshoot this better--any sort of traces,
maybe? I usually ran my test with tracing turned on for System.Data.SqlClient,
as you can see above.


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.