Read access MDB file from ASP.NET 3.5 web service on 64 bit OS

Question

I am running Windows Server 2008 / IIS 7.

From a web service, I am trying to read from a local mdb file.

If I install the target platform to any or x64, I get the error: The provider "Microsoft.JET.OLEDB.4.0" is not registered on the local machine.

If I set the target platform to x86, I get an error: An attempt was made to load a program with the wrong format.

What can I do to fix this problem?

+2

lox 27 Aug 09 at 14:25

1 answer

lox · Accepted Answer · 2009-09-01T13:36:23+0000

There is no 64-bit OLEDB provider for Jet. So there is no access to mdb on 64 bit.
An assembly compiled for a 32-bit version of IIS running on a 64-bit OS requires "Enable 32-bit applications" to be TRUE set to "Advanced Application Pool Settings" of the web service.