• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

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

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
Brogrim
Asked:
Brogrim
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now