Daniel Fisher (lennybacon.com)


OleDb, Decimal and DBConcurrencyException

I had some trouble with a WebForm, including a OleDbDataAdapter, a DataSet and uses the OleDbCommandBuilder to publish the CommandText property to the DataAdapter, that tries to update five Decimal columns in a Access database. No matter what i did the Update method of the DataAdapter threw a DBConcurrencyException. After googling a few minutes i found someting about the ODBC/JET data type limit.
So i canged the Decimal to a Double and now all works fine.



« Chris is blogging! Testing BlogJet »


I love life and I love that about people... I adore the human experience, I really adore the ... I love the contradictions of people... I don't mind being sexy and girlish and womanly, and all those things at the same time... smart and very

Write a comment