An Excel upload from the Admin console might result in any of the following when utilizing 64-bit drivers:
- It will appear as though the upload was successful but an Excel file does not show up on the Data Sources tab.
- You might get an error stating "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
- After successful upload, the created Named Ranges in the Excel file might not show up when you are creating a chart in the User application.
The iDashboards production installation supports 32-bit Apache Tomcat, but not 64-bit Tomcat. iDashboards has not necessarily evaluated all other 32-bit and 64-bit application servers, although they may work properly. The iDashboards evaluation version utilizes a 32-bit application server (Tomcat). These installations need to utilize 32-bit drivers to connect to Access and Excel data sources. If you have 64-bit ODBC drivers, which comes standard with a 64-bit system, the iDashboards application may not properly communicate with your data source.
As mentioned, iDashboards needs to run in a 32-bit application server. Please make sure to install the 32-bit AccessDatabaseEngine.exe for Office 2007 even if you have a 64-bit system.
You can download the drivers from the following link:
The Office 2007 AccessDatabaseEngine.exe drivers have been found to be more reliable for iDashboards data sources. The Office 2010 AccessDatabaseEngine.exe drivers is not as stable.
If you already have installed the Office 2010 version of the AccessDatabaseEngine.exe please uninstall and reinstall the Office 2007 version of the AccessDatabaseEngine.exe.
You might to restart the system for the above changed to take effect.
iDashboards only supports the 32bit AccessDatabaseEngine.exe drivers.
- X Platform
- Enterprise Suite