[R] rodbc windows doesn't find dsn

Jack Tanner ihok at hotmail.com
Sun Sep 5 00:27:23 CEST 2004

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?

More information about the R-help mailing list