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

---

Apples $46.33 Billion Quarter Earnings

It is a nice think to here that in the current climate of doom and gloom, there is a light in the tunnel. Not at the end yet but at least its there.

You may or may not have heard but Apple has just reported a massive $46.33 billion revenue for the last quarter of 2011, thank mainly to the huge sales of the iPhone 4S not to mention the sales of the iPad.

As you can guess all of these are way beyond anyones estimations, and I have to say this is great news especially with the recent passing of Steve Jobs, I think he would be very proud of the company.

So whats wrong with this? Now I ask you a question, if Apple has made a huge $13.06 billion profit for this period from the $46.33 billion sales, you have to ask where has all this money come from. I mean every news article you read or see is about people losing their jobs, companies going bust. So in these "so called" hard times where is this money coming from. After all most of the people who have bought the new iPhone 4S probably already had the old iPhone, and if you look at the typical user they tend to be people who see their phone as a toy, and in some if not most cases are your typical single mum or benefit scrounger.

So I ask you, can the world not see that people have more money than they are making out, and lets use this Apple success as the true judge of the economies of the world and start getting things back on track.

For more info on Apples great news go to http://www.apple.com/pr/library/2012/01/24Apple-Reports-First-Quarter-Results.html

Thanks Sean J Connolly FaceBook Me - Visit AJAX Web Development Store BuzzProperties.co.uk - Online Property Sales and Letting

---

BlackoutSOPA - Web Support against SOPA

With the current support for SOPA being testing and as more and more online giants put their weight behind the opposition of SOPA, I think that its time people said where do they fit in the whole SOPA arguement.

What is SOPA

Firstly if you dont know what SOPA is its the Stop Online Piracy Act that US congress are planning to turn into legislation, and in essence it makes sharing information online a bit more difficult, as under SOPA any websites showing copyrighted content without the owners permission will be liable for the infringement. However apart from that bit of the act the rest of it makes sense.

We need more protection from online pirates, especially in todays society where the majority of people who work in IT, particulary as web developer, designers etc carry out a lot of copyright theft, taking code from sites passing it off as their own, stealing designs. Basically in the last 10 years there has been an influx of companies claiming they can do something when they cant, they get awarded work they shouldn't and simply use the internet to find the coding they need, then pass it off as their own work. THIS MUST STOP.

Where Do I Stand

I am in support of the essence of SOPA in we need better controls to protect our hard work, yet at the same time we do not want sites such as Wikipedia, Reddit and others to be blamed for hosting copyrighted materials. This in my view is the key, we need to all work together and if a site hosts copyrighted material, they should take it down as soon as they are made aware of it, and be willing to pass details of the people on to authorities, after all civil protection doesn't give you the right to break the law.

So will I be bringing my websites down on Wednesday, No. But I do support this action in part at least.

If you have not heard of SOPA or want to know more about it, check out my other blog article on SOPA http://notjustajax.blogspot.com/2011/11/stop-online-piracy-act-sopa.html

Thanks
Sean J Connolly
 FaceBook Me

BuzzProperties.co.uk - Online Property Sales and Letting

---