Env: Windows 2003 server, .NET framework 1.1, ODBC .NET provider,
Connector/ODBC 3.51.
I'm developing a test .NET application that connects to mysql using ODBC
.net provider.
For the test I'm using this simple table
CREATE TABLE `provanuova`
(
`id` INTEGER (11) NOT NULL AUTO_INCREMENT ,
`itemString` varchar (50),
`itemDateTime` datetime,
`itemDecimal` DECIMAL (26,5),
PRIMARY KEY (id)
) TYPE=MyISAM
When I'm trying to do an insert I got the following error
"Error [07006][MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt] Restricted
data type attribute violation <sql-c-numeric>
I verified that I got this error in relation to the insertion of the
decimal field.
If I switch driver from 3.51 to 2.50 I get no error but in this case I
save the number without decimal.
Can anybody help me about this error?
Thank you
Marco Paci
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
