SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application’

Error:

SQLSTATE=IM014,Native error=0,msg='[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application'

Cause:

Using a 64bit ODBC connection when using a 32bit application.

Solution:

Create the ODBC using the 32bit ODBC connection manager located in the %WINDIR%\SysWOW64\ folder with the name odbcad32.exe

Notes:

Keep in mind, this error has to do with the application using the ODBC DSN, not the systems itself. I initially ran across this issue while testing MSDTC connections using the DTCTester.exe utility. This is a 32bit utility so it has to use a 32bit ODBC dsn.

Leave a Reply