Installed the 64 bit version of Orchestrate on an 64 bit Windows operating system but can't run the import due to the following error:-
Orchestrate Data Flow import has failed. The detailed information is as follows:
ERROR [IM014] [Microsoft] [ODBC Driver Manager] The specified DSN contains an architecture mismatch between the driver and application
Import Command:
N/A
Microsoft doesn't ship the 64 bit text driver as part of Windows. This is the reason why 64 bit driver isn't visible for Orchestrate 64 bit. In order to use Orchestrate 64 bit version to import CSV data, you must install the 64 bit text driver that is available from Microsoft Access Database Engine 2016 Redistributable (https://www.microsoft.com/en-us/download/details.aspx?id=54920).
You will then need to add the System DSN to run the CSV import via the following steps:
Log into Orchestrate System Manager
select file
Select data import configuration
select data source configuration
Click New
select ODBC data connections from Data Source Type dropdown list
Click Next
Click Manage ODBC source
Select System DSN tab and select the relevant name e.g. CSV import, 64 bit, Microsoft Text driver
Click Configure
Click Select Directory
Click OK