OLE DB Operation generated errors

This topic is locked

OLE DB Operation generated errors	12/13/2007 6:31:15 AM
ASPRunnerPro General questions
J jackmetickler author Hello there, I am new to ASP so forgive me if this is obvious. I am attempting to build a add new record page to access a very simple sql 2005 db. I am receiving the following error when I attempt to update records - <<< Record was NOT added >>> Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. How do I check OLE DB status value and can anyone point me in the right direction to solve error. Add new record page contains a few drop down lists and I have used RTF (BASIC) in the text boxes. Could that be a problem?


J	jackmetickler author 12/13/2007
	To anyone concerned: I have managed (with the assistance of ASP support) to solve my problem. Alexay sent me this info: This error happens when you enter character value to numeric field, enter string that doesn't fit in a field, put empty string to NOT NULL field etc. and on changing my text fields to nvarchar (max) - and not using RTF, the table updates. I wish to use RTF at some point so I will have to find out what data type I can use in my field. Hope this helps someone out there. All the best Jack