

The timestamp for the INI file would be updated. This file is at the below location on a 64-bit machine –Ĭlicking on No will abort the wizard. The last message box verifies if you want to overwrite the existing DSN alias in DB2CLI.INI file. Start the 32-bit ODBC Data Source Administrator Wizard from the SYSWOW64 directory.

The required DSN should be created again using this 32-bit version and it will update the Windows registry or the environment path variables appropriately. The 32-bit ODBC Data Source Administrator is in – The standard DSN creation scripts used by system administrators might use the 64-bit version because it is at the default location. A 64-bit Operating System points to the 64-bit drivers by default and uses the ODBC Data Source Administrator at – Step Error Description: The specified DSN contains an architecture mismatch between the Driver and ApplicationĭTS are 32-bit applications and need the Data Source Names (DSN) based on 32-bit ODBC drivers. Step Error Source: Microsoft OLE DB Provider for ODBC Drivers The error logs of the DTS would show the following message – Data Transformation Services packages (DTS) that use DB2 as an ODBC source, fail when the execution environment is upgraded to 64-Bit Windows Server 2008, Windows 7 etc.
