Multiple-step OLE DB operation generated errors: works in development
Posted on 2006-10-24
I am getting an error after moving from development to a production server:
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.
/newticketsave.asp, line 35
The line is:
rs("TK_DETAIL") = Request.Form("TK_DETAIL")
I can run the page local using the same data and pages and it works. On the production server, it errors out. (development is XP Pro SP2 IIS5, production is Server2003 IIS6) Checked spelling, form, etc. Field allows for nulls but the data it's passing is not null.