32 bit driver Not working

Posted on 2014-08-15
Last Modified: 2014-08-15
Good Afternoon,

I have a 32 bit corporate application running on a WIndows 2008 server.  I have modified the registry keys for both the hkey_local_machine\software\ODBC  and hkey_local_machine\software\WOW6432Node folders to ensure the MS Access Driver is pointing to the 32 bit Oracle driver installed.  I have created the System DSN to point to the Oracle 32 bit driver as well.  

The driver and setup in each of these folders has:


I have attached screen shots of the error messages I am getting in MS Access.  I believe the issue is that MS Access is still pointing to the 64 bit driver.    I am getting an architecture mismatch error between application and driver.  

Any suggestions are welcomed.

Thank you.
Question by:Tammi Warick
    LVL 24

    Expert Comment

    by:Tomas Helgi Johannsson

    And is the MS Office that is installed on the Windows 2008 Server  32 bit as well ?
    Access and the odbc driver need to be in the same 32 bit to be able to communicate between Access and odbc otherwise you get an architecture mismatch.

        Tomas Helgi

    Author Comment

    by:Tammi Warick
    Hello Tomas,

    Thank you for your reply.  the MS Office suite was installed as 64 bit -- and I am thinking this is the source of the problem.  What are your thoughts?

    My idea to only change the Access driver and ODBC to use the 32 bit driver so that the corporate application accessing the database were using the same 32 bit driver.  My team and I didn't want to change the 64 bit driver for the entire MS Office 2010 suite.  

    however, I am still encountering the mismatch error.  I have verified that the Access driver and the ODBC driver are in fact the 32 bit drivers.

    I hope this helps to clarify from my perspective.  

    Thanks again,
    LVL 24

    Accepted Solution


    The Office suite needs to be 32 bit as well as all the drivers  as I mentioned before.
    If you have an application that is 32 bit then all other drivers and in some cases (as is with the Office suite) all other apps communicating with that application needs to be 32 bit as well.
    A 32 bit Access driver can only communicate with the 32 bit Access application/database.

    Architectural difference between 32 bit and 64 bit applications makes it impossible for them to communicate between each other directly.

         Tomas Helgi

    Author Closing Comment

    by:Tammi Warick
    Thank you for your help.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now