[R] RODBC connection failed

[Prof Brian D Ripley]

On Fri, 14 Feb 2003, Charles Raux wrote:

> I am trying to restart on R after 2 months stop. Start with previously
> functioning procedure:
> "ch<-odbcConnect("dBase Files")"
> get
> "Warning message:
> ODBC connection failed in: odbcConnect("dBase Files") "
> I have tried unsuccessfully different working directories.
> The only change I see is that I am working with a new login account on
> the same machine. Microsoft ODBC is still here in c:\WINNT\system32.
> What is wrong?

DSNs are often per-user.
Try

ch<-odbcDriverConnect("")

and explore (assuming your RODBC is current).

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595