Solved

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

Posted on 2015-01-08
1
230 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
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…

746 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

11 Experts available now in Live!

Get 1:1 Help Now