That error is often related to unitialized variables, ADO parameters that are not correct for your provider, or problems with Identity values.
Post some more info about your connection string and the code that gets the value from the form to the sql statement and maybe we can spot something wrong.
quote: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
Funny you should bring this up... I started playing with Snitz the other day, and encountered this very same problem in an unMODded page (inc_profile.asp out of pop_profile.asp?mode=goEdit). Depending upon your MDAC release, OLEDB provider, and connection string, you'll find this when you try to select a field, and then move back in the row to retrieve another record. I found that bio was filled, but that hobbies, news, and quote always came up blank. I ran strSQL through QA, and it came up okay. It was once I changed it to use rs(index) to retrieve the four fields that the problem became apparent. My fix was to go from this:
It may not be completely relevant to your situation, but the error was the same, so it might be a pointer in the right direction. If you want me to take a quick glance at your code, post it up or email me, and I'll try to give you some more specific information.
Topic Locked
Posted - 27 May 2001 : 20:49:26
