<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.<br />
<br />
I installed the ODBC Connector, my database is displayed and the &quot;Test connection&quot; is coming back successful.<br />
<br />
When I try and link the tables I get the message<b> &quot;the specified dsn contains an architecture mismatch between the driver and application&quot;</b><br />
<br />
Thanks in advance
</div>
</div>


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

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.