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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +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 @[EMAIL PROTECTED] 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'
_______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
