Hi, trying to get ODBC to work with MySQL on my Mac running Leopard. I followed the instructions here: www.stats.ox.ac.uk/pub/bdr/RODBC-manual.pdf - setting up iODBC, creating a connection to MySQL (previously installed) which I tested with the iODBC tester as well as my MySQL GUI client. So far, so good.
Now, in R: - I loaded the RODBC package - executed library(RODBC) - exectuted odbcDataSources() . . . . . . which oddly: 1. does not show the connections I made in iODBC and 2. shows two sources that shouldn't exist: myodbc and "MySQL ODBC 5.1 Driver" Is there something I'm missing, or a dumb mistake in this somewhere? Despite showing that RODBC loads and works, it does not see the connections made in iODBC. Is there a link between the two that I've missed? Thanks! -- David J Petersen djpeter...@gmail.com +1 415.336.3948 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
