Displaying 1 result from an estimated 1 matches for "mysqldsn".
2007 May 02
1
Query about RODBC to access MySQL from Windows
Hi
I am trying to use RODBC in R installed on Windows to
access MySQL database (on a linux box).
I set up a DSN and specified this DSN in R as follows
library(RODBC);
channel <- odbcConnect("mysqldsn");
RODB Connection 5
Details:
case=nochange
PORT=3306
........
Although this seems to connect properly, running any
command yields NO results.
i.e. sqlQuery(channel, "show tables") yields 0 rows
when there are close to 500 tables in the database.
Ditto with any other query. It do...