• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • 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)PresidentCommented:
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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

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