[R] rodbc windows doesn't find dsn

[Jack Tanner]

Under WinXP, I have a system DSN called foo. It has stored 
username/password information. (I can click Configure in ODBC 
Administrator and then Test Data Source connects to MySQL without me 
re-entering data.)

Using RODBC, I can connect to the same database. But when I do 
odbcConnect("foo"), I get a window that requires me to re-enter 
username/password information. It seems like RODBC is not finding my 
system DSN. Am I doing something wrong?