[R] RODBC partial success

M. Edward (Ed) Borasky znmeb at aracnet.com
Sat Apr 7 15:14:06 CEST 2001

I finally managed to get R 1.2.2 on my Windows 2000 system to communicate with
a database on the same system with RODBC! For those of you who are not
Windows users, there are three types of data set names you can set up: user
DSNs, which can only be accessed by the user that defined them on the same
system, system DSNs, which can be accessed by any user on the same system, and
file DSNs, which supposedly can be accessed by other users. I have been able to
connect to both user and system DSNs using "odbcConnect" with just the DSN as
an argument, but I have not been able to find a combination of arguments that
works for file DSNs.

So my question is whether this is a bug in RODBC or if there actually is a way
to connect to a file DSN with "odbcConnect". For what I'm doing on my home
system, user and system DSNs are fine, but I use file DSNs more or less
exclusively at work, since most of the databases there are MS Access. Actually,
I am treating them as shared files -- the Access database will reside in a
shared partition on our team server (Windows 2000) and the ODBC file DSN
resides on my workstation (also Windows 2000). The one piece I haven't tried
is defining a user or system DSN on my workstation and pointing it to the
shared Access database. If *that* works I don't really need RODBC to work with
file DSNs, although it would be nice. Anybody out there been down this path??
znmeb at aracnet.com (M. Edward Borasky) http://www.aracnet.com/~znmeb

Never play leapfrog with a unicorn.

r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list