[Mono-bugs] [Bug 75667][Maj] New - Exception thrown when using SqlClient to ExecuteReader with a command of type StoredProcedure

[bugzilla-daemon at 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 mike.hull at coversant.net.

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

--- shadow/75667	2005-07-29 19:58:47.000000000 -0400
+++ shadow/75667.tmp.7827	2005-07-29 19:58:47.000000000 -0400
@@ -0,0 +1,98 @@
+Bug#: 75667
+Product: Mono: Class Libraries
+Version: 1.1
+OS: All
+OS Details: Gentoo Linux Mono 1.1.8.2, Windows XP Mono 1.1.8
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Major
+Component: Sys.Data.SqlClient
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: mike.hull at coversant.net               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Exception thrown when using SqlClient to ExecuteReader with a command of type StoredProcedure
+
+Description of Problem:
+When an SqlCommand.ExecuteReader() is executed with a CommandType of
+StoredProcedure an exception is thrown.
+
+
+Steps to reproduce the problem:
+1. See attached source file.
+2. gmcs or mcs /r:System /r:System.Data /r:System.Xml Program.cs
+3. mono Program.exe
+
+Actual Results:
+Failed with exception: System.Data.SqlClient.SqlException: 'int' is not a
+recognized CURSOR option.
+in <0x000ae> System.Data.SqlClient.SqlConnection:ErrorHandler
+(System.Object sender,
+Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e)
+in (wrapper delegate-invoke)
+System.MulticastDelegate:invoke_void_object_TdsInternalErrorMessageEventArgs
+(object,Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
+in <0x0001d> Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage
+(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs e)
+in (wrapper remoting-invoke-with-check)
+Mono.Data.Tds.Protocol.Tds:OnTdsErrorMessage
+(Mono.Data.Tds.Protocol.TdsInternalErrorMessageEventArgs)
+in <0x001b2> Mono.Data.Tds.Protocol.Tds:ProcessMessage (TdsPacketSubType
+subType)
+in (wrapper remoting-invoke-with-check)
+Mono.Data.Tds.Protocol.Tds:ProcessMessage
+(Mono.Data.Tds.Protocol.TdsPacketSubType)
+in <0x0011b> Mono.Data.Tds.Protocol.Tds:ProcessSubPacket ()
+in <0x00047> Mono.Data.Tds.Protocol.Tds:NextResult ()
+in <0x0004f> System.Data.SqlClient.SqlDataReader:NextResult ()
+in <0x000e6> System.Data.SqlClient.SqlDataReader:.ctor
+(System.Data.SqlClient.SqlCommand command)
+in (wrapper remoting-invoke-with-check)
+System.Data.SqlClient.SqlDataReader:.ctor (System.Data.SqlClient.SqlCommand)
+in <0x0006c> System.Data.SqlClient.SqlCommand:ExecuteReader
+(CommandBehavior behavior)
+
+
+Expected Results:
+Successful: <NewDataSet />
+Successful: <NewDataSet>
+  <Table>
+    <RowID>1</RowID>
+    <Name>Name0</Name>
+    <Description>Description0</Description>
+  </Table>
+</NewDataSet>
+Successful: <NewDataSet>
+  <Table>
+    <RowID>2</RowID>
+    <Name>Name1</Name>
+    <Description>Description1</Description>
+  </Table>
+</NewDataSet>
+Successful: <NewDataSet>
+  <Table>
+    <RowID>3</RowID>
+    <Name>Name2</Name>
+    <Description>Description2</Description>
+  </Table>
+</NewDataSet>
+Successful: <NewDataSet>
+  <Table>
+    <RowID>4</RowID>
+    <Name>Name3</Name>
+    <Description>Description3</Description>
+  </Table>
+</NewDataSet>
+
+How often does this happen? 
+Every Time.
+
+Additional Information:
+I've compiled it using gmcs and mcs both on windows and Linux.  I've also
+compiled it with VisualStudio 2005 Beta 2 referencing mono's mscorlib,
+System, System.Data, and System.Xml.  Same results for all. Also the mcs
+and gmcs compiled exe file executes fine using Microsoft's .NET framework
+in windows.