[R] Read in data from Microsoft SQL

Prof Brian Ripley ripley at stats.ox.ac.uk
Tue Nov 2 09:09:41 CET 2004


On Tue, 2 Nov 2004 Jan_Svatos at eurotel.cz 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: r-help-bounces at stat.math.ethz.ch
> Send: 1.11.2004 19:10:47
> To: <R-help at stat.math.ethz.ch>
> 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,                  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 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-help mailing list