How to resolve ODBC drivers error in Sagent Data Flow

Product Feature: DataFlow Server

 
Sagent clients are 32-bit. Therefore if a 32-bit driver is installed and the DSN is configured then the  Baseview Editor should work fine. 
In the case where Sagent Dataflow Service itself is 64-bit, it looks for a 64-bit ODBC connection. For this the ODBC connection must becreated one more time over the 64-bit ODBC Admin.
 
It is also possible that the 64bit driver isn't installed automatically. 

Refer help links for MS-Access-DB drivers:
http://www.microsoft.com/de-de/download/details.aspx?id=13255
http://answers.microsoft.com/en-us/office/forum/officeversion_other-access/64-bit-driver-for-dsn-for-ms-access-database/be8c0ad4-d8fd-48e0-9026-b95d84135820 
 
UPDATED:  November 20, 2017