Created On:  21 April 2011
 
When connecting to my Excel DSN, I receive error:

"*** Error: (IM014) [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"
 
This is not a SilkTest error, but an ODBC error. This occurs on a 64-bit Operating System if you use the 64-bit ODBC Data Source Administrator to configure your DSN. SilkTest needs to connect to a 32-bit excel driver. It will not operate with a 64-bit DSN.

To resolve follow the steps below:
1. Navigate to the 32-bit odbcad32.exe to configure your 32-bit Excel driver. This can be found at the following location: "C:\Windows\SysWoW64\Odbcad32.exe".
2. Click on "System DSN" tab.
3. Create a new data source and give it a unique name. 
4. Point this to your Excel document using "Select Workbook" and select "ok".
5. In your SilkTest script, change your "DSN" in your "DB_Connect" statement to make reference to this new (32-Bit) data source name.
 
Incident #2512292