MySQL Forums
Forum List  »  Connector/ODBC

Advanced Search
New Topic

Re: Bug #3028 error when updating a decimal, float or double field in .net
Posted by: Richard Creer
Date: February 04, 2005 07:19AM

I'm doing INSERT TABLE ABC (blah, Price) VALUES (XXX,9.99) where Price is DECIMAL(10,2) and I get 'Restricted datatype attribute violation (SQL_C_NUMERIC)' with myODBC 3.51. It works fine with myODBC 2.50.

As I understand it bug #3028 agrees that this doesn't work and says that it won't be fixed till myODBC 3.53 for which there is, as yet, no availability date.

As far as I can see this means that the latest version of ASP.NET, mySQL and myODBC don't work together if prices are in the database, and that must rule out very many commercial applications. I find this very strange, but perhaps the combination of ASP.NET and mySQL isn't used for commercial applications?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Bug #3028 error when updating a decimal, float or double field in .net
Richard Creer
February 03, 2005 05:03AM
Re: Bug #3028 error when updating a decimal, float or double field in .net
Rodrigo Rueda
February 03, 2005 11:48AM
Re: Bug #3028 error when updating a decimal, float or double field in .net
Richard Creer
February 03, 2005 01:00PM
Re: Bug #3028 error when updating a decimal, float or double field in .net
Rodrigo Rueda
February 03, 2005 01:12PM
Re: Bug #3028 error when updating a decimal, float or double field in .net
Richard Creer
February 04, 2005 07:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.