Resolve architecture mismatch encountered' while using ODBC connection in Sagent

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.

User-added image

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, 2017
For 64-bit DFS, use following steps:
  • Navigate to the path '%systemdrive%\Windows\System32'.
  • Run 'Odbcad32.exe'
  • Create a new ODBC connection selecting 'MS Access Database' option.
User-added image
  • Restart the Dataflow server and try to execute the plan again.
For 32-bit Dataflow Server, use following steps:
  • 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.
Also download the Microsoft Access ODBC driver which contains ODBC driver for both 64-bit and 32-bit and further execute the required installer.

If the issue is unresolved after following these steps, contact client support.