http://forums.asp.net/56.aspxDiscuss using MySQL as a data store for ASP.NET.enCommunityServer 2007 SP1 (Build: 20510.895)http://forums.asp.net/thread/299086.aspxMon, 04 Aug 2003 12:29:04 GMT4c671506-2930-414c-a40b-8bf57ded5924:299086enrico.marzorati0http://forums.asp.net/thread/299086.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=56&PostID=299086hi Marina-a, <br /> you can try : <br /> <br /> ...... <br /> <br /> UpdateCommand.CommandText = &quot;UPDATE Settori SET CODSET = ?, DESSET = ?,CODREP = ? WHERE CODSET = ?&quot; <br /> <br /> <br /> UpdateCommand.Parameters.Add(&quot;@CODSET&quot;, OdbcType.VarChar, 2).Value = cdset <br /> UpdateCommand.Parameters.Add(&quot;@DESSET&quot;, OdbcType.VarChar, 30).Value = dsset <br /> UpdateCommand.Parameters.Add(&quot;@CODREP&quot;, OdbcType.Double).Value = Cdbl(cdrep) <br /> UpdateCommand.Parameters.Add(&quot;@ID&quot;, OdbcType.varchar,2).Value = cdset <br /> .... <br /> <br /> Use Double instead of Decimal, like C programming with MySql API !http://forums.asp.net/thread/258663.aspxWed, 25 Jun 2003 14:49:16 GMT4c671506-2930-414c-a40b-8bf57ded5924:258663marinaa0http://forums.asp.net/thread/258663.aspxhttp://forums.asp.net/commentrss.aspx?SectionID=56&PostID=258663I'm using MYSQL ODBC 3.51 Driver and OdbcCommandBuilder update fields in my MySQL database. The type of the fields I'm updating is decimal(6,0) and I'm using version 1.1 of the .Net Framework. <br /> <br /> The error message I get is: <br /> &quot;System.Data.Odbc.OdbcException: ERROR [07006] [MySQL][ODBC 3.51 Driver][mysqld-4.0.10-gamma-nt] Restricted data type attribute violation(SQL_C_NUMERIC)&quot;. <br /> <br /> <br /> Any idea? <br /> Thanks!