I have an SSIS package that needs to use ODBC to connect to an Informix data source. It runs fine on my 64-bit Win7 development box but blows up on 64-bit Windows Server 2008 with the following error message:
The specified DSN contains an architecture mismatch between the Driver and Application.
I can see the informix drivers when I use odbcad32.exe in %windir%/SysWOW64/ and have created an ODBC connection there. I cannot see them when I use odbcad32.exe in %windir%/System32. The Google machine says the error message I'm seeing comes when I've created the ODBC connection using the wrong ODBC administrator engine. I'm using the IBM Informix SDK 3.70.
Maybe my Google-fu is weak, but I can't find anything useful on how to get Windows Server 2008 to allow me to see the 32-bit Informix drivers in the ODBC administrator engine from System32.
Anyone have any ideas/insights?