I was running VSExpress 2010 C# and SQLExpress 2008 on 32b XP. Due to a failure I am now on Win7 64bit. I have reinstalled VSExpress C# (64b). I installed SQLExpress (64b) however my application uses the Microsoft.ACE.OLEDB.12.0 driver to connect to a Office 2007 (32b) database. I could not get the Microsoft.ACE.OLEDB.12.0 to load on SQLExpress (64b).

What do I need to do to get Microsoft.ACE.OLEDB.12.0 working again in SQLExpress? Do I need to run the 32bit version? (I have downloaded it but am having problems getting it to install so I am asking while I uninstall all of my SQLExpress)

Thanks for the help. (I saw a lot of similar issues addressed but could not find a solution for my specific problem)

2 Answers
2

I think this post has the answer you're looking for -- download 64-bit version of ACE OLE DB driver. However, apparently it requires installing 64-bit version of Office as well.

Otherwise go and install WoW-enabled 32-bit version of SQL Server 2008 Express. Go to this download page and download SQLEXPR_x86_ENU.exe (note: the one without32 in the file name). It should install on 64-bit system.

When I try to install the 64bit version of the ACE OLE DB driver it will not allow me due to the 32 bit version of MSOffice.
–
cjjeeperAug 27 '12 at 20:36

Hmn, if installing 64-bit Office is not an option, please try WoW version of SQL Server Express. I updated my answer with instructions that should work.
–
Krzysztof KozielczykAug 27 '12 at 20:41

Okay, installing 64 bit office was not an option. Installed SQLExpress 32b SP1. In the properties for the provider I enabled Allow Inprocess. The calls to the driver now work. Thanks,
–
cjjeeperAug 27 '12 at 21:34

I had the same problem and couldn't install the 64 version because I have 32 bit office installed as well (so the 64 bit installed terminated). I changed the build of my program to x86 instead of AnyCPU and the 32 bit ACE worked as given in this Stack Overflow question