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

Version 2
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    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:

    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


    Article Number:

    000100232


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles