title: R ODBC MySQL Connection Example
body: <p>I'm trying to use RODBC to connect to a MySQL db on my computer (I'm assuming it's localhost).  I've read the package reference manual and can't figure out how to do anything (connect, set default driver, open channel, etc).  Any suggestions?</p>
  
  <p>EDIT:</p>
  
  <pre><code>&gt; install.packages("RMySQL", type="source")
  Installing package(s) into ‘C:/Users/backupSam/Documents/R/win-library/2.13’
  (as ‘lib’ is unspecified)
  trying URL 'http://lib.stat.cmu.edu/R/CRAN/src/contrib/RMySQL_0.8-0.tar.gz'
  Content type 'application/x-gzip' length 160735 bytes (156 Kb)
  opened URL
  downloaded 156 Kb
  
  * installing *source* package 'RMySQL' ...
  ERROR: configuration failed for package 'RMySQL'
  * removing 'C:/Users/backupSam/Documents/R/win-library/2.13/RMySQL'
  * restoring previous 'C:/Users/backupSam/Documents/R/win-library/2.13/RMySQL'
  
  The downloaded packages are in
          ‘C:\Users\backupSam\AppData\Local\Temp\RtmpitXEFu\downloaded_packages’
  Warning messages:
  1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/x64/R CMD INSTALL -l "C:/Users/backupSam/Documents/R/win-library/2.13"   C:\Users\BACKUP~1\AppData\Local\Temp\RtmpitXEFu/downloaded_packages/RMySQL_0.8-0.tar.gz' had status 1 
  2: In install.packages("RMySQL", type = "source") :
    installation of package 'RMySQL' had non-zero exit status
  </code></pre>