Reading Access MDB file from ASP.NET 3.5 Web Service on 64 bit OS.

views:

483

answers:

+2 Q:

Reading Access MDB file from ASP.NET 3.5 Web Service on 64 bit OS.

I run Windows Server 2008/IIS 7.

From a Web Service I attempt to read from a local mdb file.

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

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

What can I do to solve this?

There is no 64-bit OLEDB provider for Jet. So no mdb access on 64-bit.
Assembly compiled for 32-bit on IIS running on a 64-bit OS requires that "Enable 32-Bit Applications" is set to TRUE in the Advanced Settings for the Application Pool of the Web Service.

lox 2009-09-01 13:36:23

Thank you lox!!!

I was tring to do the opposite: Debug a 32-bit app with "Edit and Continue" that had a WebService in the solution. (As Edit and Continue won't work on a project in 64-bit)

RyanK 2010-01-30 15:24:34

A 64-bit version of Jet/ACE is now available in beta. I don't have the URL, but others have found it on the MS website with no issues. It exists because Access 2010 will ship in both 32- and 64-bit versions, and part of developing that is creating a 64-bit ACE. Others have claimed it solves their problem, even the beta.

David-W-Fenton 2010-01-30 17:29:06

+1 A:

However, there is currently an unfortunate limitation of the 64-bit ACE driver – it cannot co-exist with 32-bit versions of Microsoft Office.

Avneendra 2010-03-12 09:50:20

This is a very useful caveat. Thanks for posting it. However, in the context of this question (running on a web server), it's highly unlikely that Office would be installed at all, no?

David-W-Fenton 2010-03-12 18:41:09

ansaurus

tags:

views:

answers:

Reading Access MDB file from ASP.NET 3.5 Web Service on 64 bit OS.

related questions