[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