Tuesday 31 January 2012

classic asp / asp.net error 800a0e7a Provider cannot be found. It may not be properly installed.

OK so you have just bought yourself a new machine and this one has a 64 bit processor and the 64 bit operating system to match, such as Windows Server 2008 R2 64 or Windows 7 64. Now you cant wait to start playing with your new toy and setup all your websites on this new piece of kit so you start setting up all your website and projects and your new machine.

WHEN

you try to run one of your websites and you get a dreaded "800a0e7a Provider cannot be found. It may not be properly installed" error. So you check and double check your code, the configuration of your new hardware, all to no avail. So what could be causing this problem, maybe a registry problem, virus or someone else.

Simple

The most common cause of the 800a0e7a error is a data source such as a database and the fact that the new system cannot find the driver to use it, normally due to the fact that the object you are using to access your database is a 32 bit object not 64 bit, such as the MICROSOFT.JET.OLEDB.4.0 so if you are using a connection string something like

"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE="


Then this is most likely your problem, but STOP dont make any changes to your code or software READ ON The Solution to 800a8e7a is Simple

All you need to do is to make your Application Pool in IIS support 32bit applications as well as 64 bit applications, and here's how.

1. Open IIS
2. Select the website on the left you are having problems with
3. On the far right click basic settings
4. Make a note of the Application Pool the website is using

1- Select Website 2- Basic Settings 3 - App Pool


5. Click on the Application Pools Option on the left
6. Select the Application Pool you website is running on, (the one you noted down in 4 above)
7. Click on Advanced Setting on the far right.

1 - ClickApp Pool 2 - Select App Pool 3 - Click Advanced Settings

8. In the settings windows that pops up, in the General Settings change the "Enable 32-Bit Applications" option from false to TRUE and click OK

Change Enable 32-Bit Applications to TRUE

And thats it.

Simple exit out of IIS and your website will now work as it did before in your 32 bit environment.


Thanks for Reading
Sean J Connolly
 FaceBook Me

BuzzProperties.co.uk - Online Property Sales and Letting



7 comments:

Unknown said...

Hello, I read your article and found that its very informative.Also I would like to refer to your case study for learning purposes.
Professional Web Design

Sean J Connolly said...

@incion

Thanks for the great comment, glad your found my article useful.

web development company said...

Some topics over net is really cool and good to read your topic is also good and I am very happy to read it.

Web Design Macclesfield said...

I have been struggling with this just this morning.

Changing the Framwork Target, App Pool and 32-Bit settings resolved the issue.

Good guide, thank you.

DrParnassus said...

One of the best designed "How To" solutions I've come across in a long time.

Good Work!

Sean J Connolly said...

Thank you for your comments, always good to hear when my advice helps fellow techy peeps.

aman said...

thnx so mch wz havin this prblm since 2-3 days hav jst started classic asp and helpd a lot...

Online Cashback