MAXNOP8
SQL Server, SSIS, powershell
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 :
Remove Ace driver 64 bits
Remove 64 bits Office Products
Reinstall Ace 32 bits
Reinstall Office 32 bits (!)
In Bids, choose Project Properties and in "Debugging" set Run64bitsRuntime to "False".
Hope this helps :)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment