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 64-bit, while the application I was using (SSIS) could only connect to 32-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 64-bit data sources, while the second is used to manage 32-bit data sources.
If you are running a 32-bit Operating System, you will have only 32 bit drivers installed. If you are using a 64 bit machine, the default ODBC Manager will be for 64-bit data sources.
Use this ODBC Manager to Review 64-Bit Data Source Names
Use this ODBC Manager to Review 32-Bit Data Source Names
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_64 created using c:\windows\system32\odbcad32.exe
- DSN_NAME_32 created using c:\windows\sysWOW64\odbcad32.exe