trying to set the value of an integer field in a sql server database, like this

DS1.RS.AddNew
DS1.RS!PAXCount = <an integer value>
<set a few more fields>
DS1.RS.Update

when executing the line that sets the value, I get this error: -

Run-time error '-2147217887 (80040e21)':
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

this error doesnt get caught by my error trapping, and being new to ADO, I dont have a clue what an OLE DB Status Value is.

I'm off to look at the technet now, but i thought one of you folks might be able to give me an answer in plain english.

cheers!