Multiple-step OLE DB operation generated errors

[danz321]

this asp stuff is pretty annoying when i have got the experience for what i'm trying to do! wandering if someone can help me out...

im getting this database error:


Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/add_to_jobs.asp, line 22

not sure how to fix it. i have a job form that submits the info to add_to_jobs.asp which adds the form info to the database and then re-directs u to the jobs page. i started getting the problem when i made the drop down boxes in the form get the options from the database instead of coding them in html. i did this so i my work colleagues can add stuff to the form once ive left by adding to the database easily, instead of codin the html.

there's quite a lot of code so here's a couple of links to it.

http://www.intopeople.developer.graphyx.net/add_to_jobs.txt
http://www.intopeople.developer.graphyx.net/job_form.txt
http://www.intopeople.developer.graphyx.net/jobs2.txt


please somebody help!!

thanks

dan

[buntine]

Try using a static cursor. The constant value is 3.

rsAddComments.CursorType = 3

Regards.

[buntine]

According to Microsoft is has something to do with some corrupt registry keys. See this article for symptoms, causes and resolutions: http://support.microsoft.com/kb/269495/EN-US/

Regards.