Classic ASP

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

Titi25 — Sat, 02 Aug 2008 06:50:17 GMT

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

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

steve schofield — Sat, 26 Jul 2008 15:09:15 GMT

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.

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

Titi25 — Sat, 26 Jul 2008 10:52:57 GMT

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.

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

Titi25 — Wed, 23 Jul 2008 08:49:40 GMT

Thanks Rovastar for your quick help in this regard! I try it now to solve the problem.:-)

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

Rovastar — Wed, 23 Jul 2008 08:45:27 GMT

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

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

Titi25 — Wed, 23 Jul 2008 08:40:52 GMT

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?