Previous Next

• 07-23-2008, 4:40 AM

  titi25 Joined on 07-22-2008, 3:23 AM Posts 4

  Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Reply Contact Hi there I receive the followin error when I search my Access database:  "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. /database/archive/report.asp, line 99 " I removed all data from my database and then I searched again and it works properly telling me that "there is no data on your request"; but when I enter the first record and i try to serach it, gives me the aboved mentioned error '80040e21' !! Would you please tell we what should I do?

• 07-23-2008, 4:45 AM

  In reply to

  Rovastar Joined on 03-13-2008, 2:00 PM London, UK Posts 758

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Reply Contact What should you do? First Google the error. http://www.google.co.uk/search?q=80040e21&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-GB:official&client=firefox-a Whcih leads to stuff liek: http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e21-errors.html and then onto the specifics: http://databases.aspfaq.com/database/what-is-this-multiple-step-ole-db-error.html Most overused word in IT is 'should' as in 'That should work!?!'

• 07-23-2008, 4:49 AM

  In reply to

  titi25 Joined on 07-22-2008, 3:23 AM Posts 4	Re: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Reply Contact Thanks Rovastar for your quick help in this regard! I try it now to solve the problem.:-)

• 07-26-2008, 6:52 AM

  In reply to

  titi25 Joined on 07-22-2008, 3:23 AM Posts 4

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Reply Contact I have still problem with my database!! I can enter my data in the database through the online form which I have, and it is successfully done, but I cant retreive the data through my search page. Would you please to guide me what should I do? I followed all those aboved mentioned articles, but I couldn't find where is the problem, but it is clear that my index file couldn't file the relation with access database.

• 07-26-2008, 11:09 AM

  In reply to

  steve schofield Joined on 06-10-2002, 4:54 PM MI Posts 2,581	Re: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Reply Contact I'd suggest do Response.write out your search SQL statement, manually paste into your database and see if it's a formatting or data type problem. Steve Schofield Windows Server MVP - IIS http://weblogs.asp.net/steveschofield http://www.IISLogs.com Log archival solution Install, Configure, Forget

• 08-02-2008, 2:50 AM

  In reply to

  titi25 Joined on 07-22-2008, 3:23 AM Posts 4

  Re: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Reply Contact Dear Steve I don't know how should I do it! I send you the following URL which is my database search page: http://www.aarinena.org/database/archive/index.asp If you select one of the items from the drop-down list it gives you the error '80040e21' which is displayed in "report.asp" file. I like to send you the file(report.asp) as well, but there is no attachment icon in this forum to attach some files. Would you please help me to find where is the problem. Best regards Titi