22 April 2009

2007 Office System Driver and 64 bit architecture

I wrote a spread sheet upload component for our web application at work. We have now decided to move to 64 bit architecture and an upgrade from .Net Framework 2.0 to 3.5.

On the initial analysis of this migration we realised that the 2007 Office System Driver used does not support 64 bit

Solution:
So I did a bit of research and it turns out that the solution is to compile you application in 32 bit mode, which sux for us as we can’t utilise the 64 bit

To compile you applications in 32 bit do the following:

1. Open menu "Build/Configuration Manager..."
2. Select "" in the "Active solution platform:" combobox
3. Select "x86" and click ok.

With regards from Walter Wang [MSFT]

There does not seem to be a planned release for a 64 bit version

Tags
2007 Office System Driver: Data Connectivity Components 64 bit
Access Database Engine
Microsoft.ACE.OLEDB.12.0

1 comment:

Juancho said...

Useful mate, useful..