Problem Writing to SQL
Posted on 2006-11-17
I am having difficulties writing to a SQL database. The field I am having problems with is a decimal format. With a length of 5 characters, a precision of 9 and a scale of 6. I'm not exactly sure what all of those mean (I didn't create the database), but the error message that I am getting is as follows:
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."
If I change the data type to varchar in the database, the program runs through fine.
The # it is trying to enter to the database is: 3801.5784
Thanks in advance for the help.