Product Feature: DataFlow Server
Issue
While using 'MS Access Database' ODBC connection in Sagent, 'The specified DSN contains an architecture mismatch between the Driver and Application' error is encountered.

Cause
This could occur if Dataflow server is 64-bit and 32-bit ODBC driver is used to access the '.mdb' file. This can also occur if Dataflow server is 32-bit and ODBC driver used is 64-bit.
Resolution
UPDATED: September 14, 2017For 64-bit DFS, use following steps:
If the issue is unresolved after following these steps, contact client support.
- Navigate to the path '%systemdrive%\Windows\System32'.
- Run 'Odbcad32.exe'
- Create a new ODBC connection selecting 'MS Access Database' option.
- Restart the Dataflow server and try to execute the plan again.
- Navigate to the path '%systemdrive%\Windows\SysWOW64'.
- Run 'Odbcad32.exe'
- Create a new ODBC connection selecting 'MS Access Database' option.
- Restart the Dataflow server and try to execute the plan again.
If the issue is unresolved after following these steps, contact client support.