title: Error Trying to Connect R to MySQL using RODBC
body: <p>I am attempting to connect R to a MySQL database via RODBC (in Win 7 environment), but cannot get past the following error:</p>
  
  <pre><code>[RODBC] ERROR: state IM014, code 0, message [Microsoft][ODBC Driver Manager] The specified     DSN contains an architecture mismatch between the Driver and Application
  </code></pre>
  
  <p>After entering the following command:</p>
  
  <pre><code>odbcConnect(dsn,uid="My_UID",pwd="My_PWD")
  </code></pre>
  
  <p>I have successfully created a driver for the database by following the odbc wizard, and have installed the RODBC package into RStudio (ver 0.98.490). The MySQL is running on 32bit, I have the 32bit driver installed and working, and my RStudio is also 32bit. I know that the driver is working since both the test connection in config. works, as do queries run on excel using the driver. </p>
  
  <p>What can I do to get the connection to work in R? </p>
  
  <p>(Previous responses to this question seem to have been removed.)</p>
  
  <p>Thanks in advance!</p>