Resolve DSN architecture mismatch between the driver and application

Question

Running Windows 7 Professional // System Type: 64-Bit Operating Systems // Microsoft Office 2013 32-Bit Edition // How do I resolve ODBC architecture issues when trying to connect to MS Access data source?

Answer 1

Answer is here

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 2

Still trying to get this ODBC connection issue resolved.

I was able to get to the 32-Bit ODBC Data Source Administration window; however, I'm not seeing the 32-Bit driver...ODBCJT32.DLL.

Do I need to download this...https://www.microsoft.com/en-us/download/details.aspx?id=13255

Answer 3

Hi Levendowski,

do you mean that currently no any odbc driver is installed on your machine ?

other thing you had mentioned that ,"I was able to get to the 32-Bit ODBC Data Source Administration window".

do you mean you can able to access below window?

please let us know about this so that we can try to suggest you further.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 4

You not really stated what application you are attempting to use with connecting to Access.

The above link is correct, and you note that you have two database engines in the resulting download (one is x32, and other is x64). You ONLY need that download if you don't have Access installed already.

Since you "hint" that you looking to use x32, then one has to assume the other application is also x32. So from the above download, you need to install AccessDataBaseEngine (as opposed to the x64 bit version which from above is AccessDataBaseEngine64).

Note that you as a general rule will need to launch the x32 bit version of the ODBC manager.

windows+R key (to launch run window), and then type in this:

c:\Windows\SysWOW64\odbcad32.exe

So the above should show the access driver.

Keep in mind that is it rather difficult to have x32 and x64 drivers for Access on a given machine at the same time.

If the computer in question already has Access installed, then you don’t need nor want to install the above database drivers.

Regards,
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada