This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
Remedy AR System Server v9.x, v8.1.x
Issue: Error configuring ODBC connection with Excel - Version Mismatch
[Microsoft][ODBC Driver Manager] - The specified DSN contains an architecture Mismatch between driver and Application
The possible reasons for encountering issue about version mismatch:
1- If you attempt to do the following on a 64-bit Windows machine:
- Connect a 64-bit application to a data source for a 32-bit ODBC driver.
- Connect a 32-bit application to a data source for a 64-bit ODBC driver.
Example, you are using 32-bit ODBC driver, but you are using an Excel application that is 64-bit.
Use the 32 bit Excel.
2- An alternative is to use the JDBC driver instead.
Remedy ODBC connection is only available in 32-bit