[Mono-bugs] [Bug 81916][Wis] New - When i use the Command.Prepare(), the query doesn't work

[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 marceloalmeida at inb.gov.br.

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

--- shadow/81916	2007-06-20 14:19:50.000000000 -0400
+++ shadow/81916.tmp.14884	2007-06-20 14:19:50.000000000 -0400
@@ -0,0 +1,62 @@
+Bug#: 81916
+Product: Mono: Class Libraries
+Version: 1.2
+OS: GNU/Linux [Other]
+OS Details: 
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Wishlist
+Component: Sys.Data.SqlClient
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: marceloalmeida at inb.gov.br               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: When i use the Command.Prepare(), the query doesn't work
+
+Please fill in this template when reporting a bug, unless you know what 
+you are doing.
+Description of Problem:
+
+When i use the Command.Prepare(), with a SQL Server 7, the 
+Command.ExecuteReader() returns the error: "Line 1: Incorrect syntax 
+near ','."
+
+Steps to reproduce the problem:
+1. Create a command
+2. Call Command.Prepare()
+3. Call DataReader = Command.ExecuteReader()
+
+Actual Results:
+Line 1: Incorrect syntax near ','.
+
+Expected Results:
+The records from database
+
+How often does this happen? 
+always
+
+Additional Information:
+
+I am using a connection created by the 
+class "System.Data.Common.DbProviderFactory"
+The command have some parameters.
+
+Traces from SQL Server:
+ * With "Prepare()"
+ - 1º command executed:
+declare @P1 int
+set @P1=NULL
+exec sp_prepare @P1=@P1 output, @P2=N'', @P3=N'SELECT aeCodPessoa, 
+aeMatFunc, aeCracha, aeCodPonto FROM vwAcessosEmpregados ORDER BY 
+aeCodPonto, aeMatFunc'
+select @P1
+
+ - 2º command executed (the problem ','):
+exec sp_execute 1, 
+
+ * Without "Prepare()"
+exec sp_executesql N'SELECT aeCodPessoa, aeMatFunc, aeCracha, aeCodPonto
+FROM vwAcessosEmpregados ORDER BY aeCodPonto, aeMatFunc'