Symptoms

When you use the 64-bit version of Report Commander to process a report that uses the DAO driver to connect to Microsoft Excel or Microsoft Access, processing fails with an error message similar to the following:

Export failed: Failed to load database information.
Error in File MYREPORT {1DF066D4-6463-467D-99AB-5C9A84BC8AD0}.rpt:
Failed to load database information.: Failed to load database information.

Cause

This happens because there is no 64-bit version of the DAO driver.

Resolution

For most users the simplest solution is to uninstall the 64-bit version of Report Commander and install the 32-bit version instead.

Alternatively you can install the 64-bit version of the Microsoft Access Database Engine and modify your report to use that driver instead of the DAO driver. However, you cannot install both the 64-bit and 32-bit versions of the database engine on the same computer.