Added: October/07/2008 at 10:51pm | IP Logged

Please help with error 80040e21. There's only one related post and it doesn't provide any answer.

When login into the admin area (.../aspprotect/password_admin/default.asp) I get the following error message:

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.

/aspprotect/password_admin/database_log_inc.asp, line 85

Then, I hit the back button on the browser, and I'm in.

When trying to access a protected page, I get a similar 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.

C:\WEBS\WEBNAME\SECUREDAREA\..\aspprotect\check_user_inc.asp /scripts/database_log_inc.asp, line 85

If I had entered an authorized username and password, hitting the back button takes me to the protected page. If I had entered an unauthorized username and password, hitting the back button takes me back to the login page.

Any pointers would be greatly appreciated!

Added: October/07/2008 at 11:13pm | IP Logged

weird stuff.. uncommon errors thus nothing posted about it

let's see your connection string and what version of the access database are you using ?

one more thing.. what is the regional LCID setting of your server ?
the server info page will tell you if you are not sure..

Added: October/08/2008 at 3:31pm | IP Logged

Thank you for your prompt response. If you think this is weird, then at least that tells me that error 80040e21 is not another way of calling you a moron.

At this point I converted my small site to aspx, and will let you know if I get this error again.

Added: October/08/2008 at 4:21pm | IP Logged

No luck!

I was able to successfully install the ASPProtect.NET add-on -- testprotect test was successful. Can get into the admin area and generate code to protext the aspx pages.

However, as yesterday, I still get the error 80040e21 after entering my credentials. I have to hit the Back button on the browser to become fully logged-in.

Here's the connection string I used when configuring the ASPProtect application:

DBQ=C:\Webs\FNXSB4\aspprotect\data\database\ASPProtect_acces s2002.mdb;Driver={Microsoft Access Driver (*.mdb)};UID=Admin;Password=temp

And this is what I now have on the web.config file:

<add key="ASPPConnStr" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Webs\FNXSB4\aspprotect\data\database\ASPProtect_ac cess2002.mdb;Jet OLEDB:Database Password=temp" />

As you can see, I'm using the default access2002 db.

I'm using a Vista machine --that fortunately runs well-- with IIS 7. It is set for the English Canada region dd/mm/yyyy. The ASPProtect application's date has also been set the same way.

Hopefully this gives you enough information to assist me.

In the meantime, thank you very much in advance!

Added: October/08/2008 at 4:44pm | IP Logged

Ok, well that free ASP.NET add on is not supported so I am not going to discuss that.

As for error problem though when running the classic asp files I need you to try some things...

Now I do not technically support installations when running on local machines especially vista installations but I will try and help regardless.

Let's start with the different versions of the database file.
http://www.aspprotect.com/files/ASPProtect_v8_Database_Versi ons.zip

I need you try each alternate database and see if the error comes up under all of them. It is what I would do if I were in the server troubleshooting myself. Something I can't really do because it's your local machine.

I am also a little concerned about permissions, odbc drivers, and the whole vista thing but let's start with the different databases.

I am running vista ultimate 64 bit here on one of machines and I am going to play around with it in the meantime and see if I can think of anything.

Added: October/08/2008 at 5:45pm | IP Logged

ok, so I just installed IIS7 on a 2 day old installation of vista ultimate 64 bit.

I initially had an issue with 64 bit iis7 not being able to connect to access databases ... after a google or two I fixed that issue with something I read here
http://forums.iis.net/t/1066385.aspx

anyway... then everything with a fresh aspprotect installation runs perfectly.. no errors at all.. I am connecting to the 2002 version of the database with a similar connection string to the one your using..

How does this help you ?  I guess it really doesn't at this point.

Added: October/09/2008 at 4:42pm | IP Logged

I have lots and lots of people using this and my other apps in windows 2008 server. I also have a 2008 server here that I use for testing.

Anwya, 1st I have ever heard of this IPv4 or IPv6 stuff.,

Good to know though... and glad ya sorted whatever it is you have going on out.