Ace.OLEDB 12.0 Doesn't work on SQL 2012
-
Tuesday, June 05, 2012 2:09 AM
Over the weekend we upgraded our production data warehouse sql cluster. I have to assume testing on the oledb was missed. Now we are running into issues with excel and sharepoint list openrowsets failing because of ACE.OLEDB.12.0 on Sql Server 2012 not working.
I have seen some comments on the boards about beta 14.0. Does anyone have any suggestions or ideas on getting Ace.OLEDB 12 working on 2012 or a link to download 14?
Any ideas or suggestions would be great.
Thanks
Bryan
fsugeiger
All Replies
-
Tuesday, June 05, 2012 12:44 PM
I ran into this just the other day and fixed it by installing the 2007 Office System Driver: Data Connectivity Components. This solved my issue.
If that installation does not fix the issue for you, try the Microsoft Access Database Engine 2010 Redistributable.
Between those two, you should be set.
HTH.
- Edited by Don_Don Tuesday, June 05, 2012 12:45 PM fixed the links.
- Marked As Answer by Iric WenModerator Wednesday, June 13, 2012 9:45 AM
.png)
