Friday, July 20, 2012

Ace oledb cannot be found with oledb connection (ssis)

Currently on my workstation I have Office 2010 64 bits, and Ace oledb driver 64 bits. Working in BIDS I could not find the Ace driver available to create a new Oledb Connection.

Since BIDS is 32 bits I had to :
  1. Remove Ace driver 64 bits
  2. Remove 64 bits Office Products
  3. Reinstall Ace 32 bits
  4. Reinstall Office 32 bits (!)
  5. In Bids, choose Project Properties and  in "Debugging"  set Run64bitsRuntime to "False".
Hope this helps :)

No comments:

Post a Comment