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
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
