Remedy - Server - ODBC Driver Connection Error: "[Microsoft][ODBC Driver Manager] - The specified DSN contains an architecture Mismatch between driver and Application"

Knowledge Article

Article Number

000283474

Old Article Number

000100232

Article Type

FAQ/Procedural

Title

Remedy - Server - ODBC Driver Connection Error: "[Microsoft][ODBC Driver Manager] - The specified DSN contains an architecture Mismatch between driver and Application"

Summary

Attempting to integrate Remedy AR System Database with Excel application

Product

Remedy AR System Server

Component

AR System

Applies to

Remedy AR System Server v9.x, v8.1.x

Question

Issue: Error configuring ODBC connection with Excel - Version Mismatch
............
[Microsoft][ODBC Driver Manager] - The specified DSN contains an architecture Mismatch between driver and Application
............

Answer

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

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.
- https://communities.bmc.com/docs/DOC-22516

ADDITIONAL INFORMATION:
Remedy ODBC connection is only available in 32-bit

Attachment(s):