IIS 5 & IIS 6
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Last post Aug 02, 2008 07:50 AM by titi25
Jul 23, 2008 09:40 AM|titi25|LINK
Hi there I receive the followin error when I search my Access database:
"Microsoft OLE DB Provider for ODBC Drivers
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?
Jul 23, 2008 09:45 AM|Rovastar|LINK
What should you do?
First Google the error.
Whcih leads to stuff liek:
and then onto the specifics:
Jul 23, 2008 09:49 AM|titi25|LINK
Thanks Rovastar for your quick help in this regard! I try it now to solve the problem.:-)
Jul 26, 2008 11:52 AM|titi25|LINK
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.
Jul 26, 2008 04:09 PM|steve schofield|LINK
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.
Windows Server MVP - IIS
Log archival solution
Install, Configure, Forget
Aug 02, 2008 07:50 AM|titi25|LINK
I don't know how should I do it!
I send you the following URL which is my database search page:
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.