ODBC--call failed.[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application (#0)

Question

I need to establish a connection between an Access 2003 database (32 bit) and an 11g 64 bit Oracle database on a server. I am running Windows 7 on a 64 bit laptop. I did a clean install of Oracle 11g for 64 bit. I have no problem accessing the Oracle database via the Oracle SQL Developer. I just have a problem from within Access. I hope someone can help me. I've been fighting this for several months. Thanks in advance!

Answer 1

When you create the DSN, you need to use C:\Windows\SysWOW64\odbcad32.exe. Instead of C:\Windows\system32\odbcad32.exe. The DSN created by latter odbcad32.exe is for 64 bit application use.

Answer 2

Thanks! I created the DSN, but now when I select that DSN from within the ODBC interface within Access, I get a Microsoft ODBC for Oracle error that says:

 "The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corp and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use this driver until these components have been installed."

I have already installed Oracle Client 11g. What do I need to try next?

Thanks for your help! 

Answer 3

Could you have a try to install Oracle Client 11g 32 bit version on your 64 bit laptop?

Some useful posts:
http://stackoverflow.com/questions/1691929/running-oracle-11g-r1-on-windows-7-x64-getting-64-bit-error
http://stackoverflow.com/questions/832695/connecting-to-oracle-with-32-bit-apps-running-on-vista-64-bit

Answer 4

Thanks a lot Ronggang... It has really saved my lot of time but I had to make connection with SQL SERVER rather than Oracle.

Answer 5

STalha.Munir,

To make other people easier to find your topic and provide fast response, could you please create a new thread and describe your issue more detailed in your new thread? Thanks.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help

Answer 6

Thank you very much for this info. It helped me solve an issue with Oracle drivers on a 2008 server . I didn't realize that just running odbcad32.exe from start/run will open 64 bit ODBC administrator.