VERIFIED SOLUTION i
X

Resolve architecture mismatch encountered' while using ODBC connection in Sagent

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.

Environment Details

Product Feature: DataFlow Server

Downloads

  • No Downloads