[Mono-bugs] [Bug 60033][Maj] Changed - SqlDataAdapter.Fill throws SqlException "Invalid object name 'sp_reset_conection'"

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by cmyers@austin.rr.com.

http://bugzilla.ximian.com/show_bug.cgi?id=60033

--- shadow/60033	2004-08-03 23:07:32.000000000 -0400
+++ shadow/60033.tmp.18028	2004-08-03 23:07:47.000000000 -0400
@@ -205,6 +205,43 @@
 from a table.
 
 ------- Additional Comments From cmyers@austin.rr.com  2004-08-03 23:07 -------
 Created an attachment (id=8860)
 Simple cmd-line test case make sure to run with "mono monotest.exe"
 
+
+------- Additional Comments From cmyers@austin.rr.com  2004-08-03 23:07 -------
+Umadevi and I had some email conversations and I wasn't good about 
+keep bugzilla updated. Here's the gist of what I sent to him:
+
+Umadevi,
+
+Ok, so I gathered all my samples together and after a long struggle, 
+I figured out that it is rather quite simple...
+
+Create a connection, open it, execute something, close it, open it 
+again, execute something, close it, open it one more time (3 times), 
+then try to execute something (anything... reader, nonquery, scalar, 
+etc).
+
+Basically, the 3rd time you open the same connection after having 
+closed it twice, any operations fail from then on.
+
+I tried tracing through the mono.data.tds code but I couldn't find 
+out where the problem is actually happening.
+
+The stack trace is somewhat useless as the problem has already 
+happened and we're just now getting the error back from the sp_reset 
+when we try to call our ExecuteWhatever.
+
+I figured before I spend a bunch of time trying to understand how the 
+TDS protocol is implemented and how the thread pooling works (where I 
+believe the problem lies); I thought you might know right away where 
+it is. If not, I can help you (if you need it?) try to trace through 
+this. I'm willing if you need any help.
+
+Do you wish me to update bugzilla with this new information?
+
+Attached is a simple example I used.
+
+Sincerely,
+Chad Myers