How to set up ODBC for RODBC

• Download a connector / ODBC for your platform & Install it

      http://dev.mysql.com/downloads/connector/odbc/

• Add "MySQL ODBC 5.2w Driver" (or yours installed) on Control Panel >> Administrator Tool >> Data Sources (ODBC).

• Put Connection Parameters. Last Parameters 'Database' would be listed if all inputs are correct.

• Test example below.

library(RODBC)
 
con <- odbcConnect("RODBC", uid="myid", pwd="mypw")
 
raw <- sqlQuery(con, "SELECT * FROM table1");