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? Thanks Charles Raux --------------- Charles RAUX, Laboratoire d'Economie des Transports CNRS-Universit? Lumi?re Lyon 2-ENTPE email : charles.raux at let.ish-lyon.cnrs.fr http://www.ish-lyon.cnrs.fr/let
try: ch <- odbcConnect("dBase Files","","") Perhaps you should avoid the space in your dsn name !? regards,christian 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? Thanks Charles Raux --------------- Charles RAUX, Laboratoire d'Economie des Transports CNRS-Universit? Lumi?re Lyon 2-ENTPE email : charles.raux at let.ish-lyon.cnrs.fr http://www.ish-lyon.cnrs.fr/let ______________________________________________ R-help at stat.math.ethz.ch mailing list http://www.stat.math.ethz.ch/mailman/listinfo/r-help
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