Ajax CascadingDropDown works on local but not on IIS

[pfeill]

ASP.NET VB environment, current
I have a simple aspx page with 3 Ajax cascading drop down linked into an Access database. Service to load asmx pulls car make then car model then car style from simple tables in Access MDB file.
The two work PERFECT when one selects VIEW IN BROWSER in Visual Web Developer 2010 Express.

When i try to run it on the "production" IIS server all convention web pages load fine but the ASPX Ajax page displays but only shows Method Error 500 in pulldowns. I changed pool to CLASSIC 4 and in that case i get 400 and no page loads at all, though the rest of the html load fine.

I read thru 50 people having seeimingly similar problems. What do i need to do to get Ajax talking to the database loading the form as it does so well on the "local" test server with Studio?

P

[pfeill]

Found the answer! how cryptic, took 2 secs and works like a charm! Hope this saves someone else the grief I spent looking for the answer.....

I loaded another Ajax request and got this message:
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

Here is the simple yet perfectly functioning result:

You need to run Access database applications in a 32 bit asp.net application pool. You do that via your IIS admin.

Open IIS manager, select Application Pools, select the application pool you are using, click on Advanced Settings in the right-hand menu. Under General, set "Enable 32-Bit Applications" to "True". It defaults to FALSE!