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=79880 --- shadow/79880 2006-11-09 13:07:15.000000000 -0500 +++ shadow/79880.tmp.11569 2006-11-09 13:07:15.000000000 -0500 @@ -0,0 +1,53 @@ +Bug#: 79880 +Product: Mono: Class Libraries +Version: 1.1 +OS: +OS Details: +Status: NEW +Resolution: +Severity: +Priority: Major +Component: Sys.Data.SqlClient +AssignedTo: [EMAIL PROTECTED] +ReportedBy: [EMAIL PROTECTED] +QAContact: [EMAIL PROTECTED] +TargetMilestone: --- +URL: +Cc: +Summary: "create view" fails + +Please fill in this template when reporting a bug, unless you know what you +are doing. +Description of Problem: +I am using Mono 1.18 against a MS SqlServer 2000. Note that the server +version is important. + +I am trying to create a new VIEW through the SqlClient and it is failing. +The statement is something like: + create view PAUL_TEST_VIEW as select * from Region + +I put this into a SqlCommand and execute, and it fails with a sql syntax +error back from the server. + +The problem is that the TDS70.cs code adds a ";" (semi-colon) at the end of +the statement. This is *NOT* allow specifically for a "create view" statement. + +Steps to reproduce the problem: +1. Edit viewBug.cs (to be attached) to set a useful username and password. +2. Compile and run against SqlServer 2000 +3. + +Actual Results: +Get: + +Unhandled Exception: System.Data.SqlClient.SqlException: Line 1: Incorrect +syntax near ';'. + + +Expected Results: +View should be created. This program does work under MS .NET. + +How often does this happen? +Always. + +Additional Information: _______________________________________________ mono-bugs maillist - [email protected] http://lists.ximian.com/mailman/listinfo/mono-bugs
