Solved

the specified dsn contains an architecture mismatch between the driver and application

Posted on 2015-01-08
1
243 Views
Last Modified: 2015-01-08
Can anybody explain in plain English how I resolve the above, there is a lot of information on the net but I cannot get my ODBC working.

I have a MySQL database on a server, I downloaded the correct ODBC as per other PCs that are working on this configuration. I have a 64 bit PC with Windows 7 Professional and Office 2010 (32 bit) installed.

I installed the ODBC Connector, my database is displayed and the "Test connection" is coming back successful.

When I try and link the tables I get the message "the specified dsn contains an architecture mismatch between the driver and application"

Thanks in advance
0
Comment
Question by:Brogrim
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 40538292
1. From the control panel, using the ODBC Data Manager Shortcut, delete the DSN if it exists.

2. Using the 32 bit version of the ODBC admin applet:

 C:\Windows\SystemWOW64\ODBCad32.exe

 Delete the DSN if it exists.

3. Using the same program as #2, re-create the DSN.

 Make sure it's a system DSN and that you are selecting a 32 bit driver for the datasource.

Jim.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

749 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