On Tue, 2 Nov 2004 [EMAIL PROTECTED] wrote: > Hi, > > the DSN should be exactly the same as "name" of the (probably system) DSN > stated in Windows ODBC settings. > Just keep in mind, that DSN in general often holds information about the > Default Database, and that switching database os stating database as > prefix may be necessary.
Yes, assuming this _is_ on Windows (unstated). In that case and under RGui, just use odbcDriverConnect() and you will get dialog boxes to select a dsn, or setup a temporary one (via the New button). > > Jan > > > - - - Original message: - - - > From: [EMAIL PROTECTED] > Send: 1.11.2004 19:10:47 > To: <[EMAIL PROTECTED]> > Subject: [R] Read in data from Microsoft SQL > > Hi, > > I am trying to read data from Microsoft SQL. I tried to use odbcConnect > (in RODBC) but failed. What should the "dsn" be? Does anyone know how to > do it? I will appreciate it. > > Thank you! > > Xiaorong -- Brian D. Ripley, [EMAIL PROTECTED] 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 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html