ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Did you create a DSN, but your application cannot access the DSN?

I created a DSN, but could not connect via SSIS. It seems that the DSN I created was 32-bit, while the application I was using (SSIS) could only connect to 64-bit DSNs.

After some research I have realized that there are two different ODBC Administrator runtimes on a 64-bit machine. The first ODBC Manager is used to manage 32-bit data sources, while the second is used to manage 64-bit data sources.

Use this ODBC Manager to Review 32 Bit Data Source Names

c:\windows\system32\odbcad32.exe

Use this ODBC Manager to Review 64 Bit Data Source Names

c:\windows\sysWOW64\odbcad32.exe

If you are trying to access a DSN in your application and receive the error “ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application” check to see if you have a DSN configured for the architecture of your application ( 32-bit / 64-bit ).

I create my DSNs twice – once for 32 bit architecture and once for 64 bit architecture. My naming convention is as follows:

• DSN_NAME created using c:\windows\system32\odbcad32.exe
• DSN_NAME_64 created using c:\windows\sysWOW64\odbcad32.exe

Good Luck

Advertisement