[Mono-bugs] [Bug 75819][Nor] New - Unrecognized C_parameter type

[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 jwaiz at icomedv.de.

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

--- shadow/75819	2005-08-15 03:47:50.000000000 -0400
+++ shadow/75819.tmp.10001	2005-08-15 03:47:50.000000000 -0400
@@ -0,0 +1,89 @@
+Bug#: 75819
+Product: Mono: Runtime
+Version: 1.1
+OS: Debian Woody
+OS Details: Debian
+Status: NEW   
+Resolution: 
+Severity: 
+Priority: Normal
+Component: JIT
+AssignedTo: mono-bugs at ximian.com                            
+ReportedBy: jwaiz at icomedv.de               
+QAContact: mono-bugs at ximian.com
+TargetMilestone: ---
+URL: 
+Cc: 
+Summary: Unrecognized C_parameter type 
+
+Problem will happen, when trying to run a Insert- or Update-Statement. I do
+this like (Shortform - just a Sample *s*):
+
+// ----------bof
+string cPrKey = (string) ViewState["Company_ID"];
+
+cStmnt = "UPDATE CompanySTD SET " +
+         "CompanyName1  = ?," +
+         "CompanyName2  = ?," +
+         "WHERE PK_CompanySTD = '" + cPrKey + "'";
+
+oVBXConn.Command.Parameters.Add( "@CompanyName1",
+                                 CompanyName1.Text.Trim() );
+oVBXConn.Command.Parameters.Add( "@CompanyName2",
+                                 CompanyName2.Text.Trim() );
+
+
+OdbcCommand.CommandText = cStmnt
+OdbcCommand.ExecuteNonQuery()
+// ----------eof
+
+Trying to change it like:
+
+// ----------bof
+OdbcParameter oParam1 = 
+  oVBXConn.Command.Parameters.Add( "@CompanyName1",
+                                   OdbcType.VarChar );
+oParam1.Value = CompanyName1.Text.Trim()
+// ----------eof
+
+with the same Result. Stack Trace will be:
+
+System.Data.Odbc.OdbcException: [unixODBC]Unrecognized C_parameter type in
+copy_statement_with_parameters
+in <0x00128> System.Data.Odbc.OdbcCommand:ExecSQL (System.String sql)
+in (wrapper remoting-invoke-with-check)
+System.Data.Odbc.OdbcCommand:ExecSQL (string)
+in <0x00076> System.Data.Odbc.OdbcCommand:ExecuteNonQuery (Boolean freeHandle)
+in (wrapper remoting-invoke-with-check)
+System.Data.Odbc.OdbcCommand:ExecuteNonQuery (bool)
+in <0x0000f> System.Data.Odbc.OdbcCommand:ExecuteNonQuery ()
+in (wrapper remoting-invoke-with-check)
+System.Data.Odbc.OdbcCommand:ExecuteNonQuery ()
+in <0x00441>
+DevProjects_IComVBX.VBXForms.RegularDataMainCompanyData:btnSave_Click
+(System.Object sender, System.EventArgs e)
+in (wrapper delegate-invoke)
+System.MulticastDelegate:invoke_void_object_EventArgs (object,System.EventArgs)
+in <0x0006e> System.Web.UI.WebControls.Button:OnClick (System.EventArgs e)
+in <0x00040>
+System.Web.UI.WebControls.Button:System.Web.UI.IPostBackEventHandler.RaisePostBackEvent
+(System.String eventArgument)
+in <0x00016> System.Web.UI.Page:RaisePostBackEvent (IPostBackEventHandler
+sourceControl, System.String eventArgument)
+in <0x00033> System.Web.UI.Page:RaisePostBackEvents ()
+in <0x00238> System.Web.UI.Page:InternalProcessRequest ()
+in <0x000a9> System.Web.UI.Page:ProcessRequest (System.Web.HttpContext context)
+in <0x00233> System.Web.HttpApplication+ExecuteHandlerState:Execute ()
+in <0x0007c> System.Web.HttpApplication+StateMachine:ExecuteState
+(IStateHandler state, System.Boolean readysync)
+
+This happens, when starting from the Mono-Runtime. Testing via
+Localhost-Runtime under Windows, everything works fine.
+
+Working with:
+Debian-Sarge
+Mono 1.1.8
+PostgreSQL 8.0.3
+
+TIA
+Jan Waiz