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