[R] Help - Getting ODBC connection to work with MySQL

[David Petersen]

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
djpetersen at gmail.com
+1 415.336.3948