Excel data sources are missing, unavailable, do not display in the drop down list, or are displayed, but smartconnect throws an error saying it cannot find a valid data source or driver.
This is because Smartconnect is using the 32 bit Microsoft Access Database Engine required for Excel data connections. (This is dependant on the original drivers used to create the original map. If the original map was created using 64-bit drivers, it will need 64 bit drivers on all clients. If the original map was created using 32-bit drivers, it will need 32-bit drivers on all clients)
These components are usually installed when you do a full install of office, however, if the client is using 64-bit Office, then it installs the 64-bit Access Database engine.
To resolve this issue, you must install the 32-bit Microsoft Access Database Engine, however, if you alrayd have 64-bit office installed, you will get an error saying you cannot install the 32-bit drivers because 64-bit drivers are already installed.
To get around this, run the install from a command line or batch file with the /passive flag
Example
C:\Accessdatabaseengine.exe /passive
will force the install even if 64-bit is already installed.
Access Database Engine Downloads
http://www.microsoft.com/en-us/download/details.aspx?id=13255
Original Post
http://blog.codefluententities.com/2011/01/20/microsoft-access-database-engine-2010-redistributable/
No comments:
Post a Comment