<![CDATA[Dundas Support Zone - Excel and Access files on 64-bit Dundas Dashboard]]>http://support.dundas.com/Dashboard5.64bit-excel-and-access.ashxWed, 17 Jun 2020 20:06:34 GMTScrewTurn Wiki RSS Feed Generator<![CDATA[Excel and Access files on 64-bit Dundas Dashboard]]>http://support.dundas.com/Dashboard5.64bit-excel-and-access.ashx

Problem

If you have installed &dw; on a 64-bit system, and need to create a data connector for an Excel spreadsheet or Access database, you will get an error message:

Error when creating a data connector for Access database.

Error when creating a data connector for Access database.


Solution

A 64-bit JET or ACE driver is required when you are running a 64-bit application. You have three options:

  1. Install the 64-bit driver: Microsoft Access Database Engine 2010 Redistributable
  2. Run your IIS or application pool in 32-bit mode, so that the 32-bit drivers will function correctly with Dundas Dashboard. In this case, you will also need to configure the Dundas Dashboard Scheduler to run in 32-bit mode, or else scheduled imports will not work.
  3. If your machine is running Windows 64-bit and you have Office 32-bit installed, you can force the 64-bit Access driver to install by running the installer with the following command: AccessDatabaseEngine_x64.exe /passive

Related topics

]]>
Julius M. (juliusm@dundas.com)Mon, 17 Dec 2012 18:40:05 GMTF21F90AA1A6D351EB24087FB5DEDAC63