Message-ID: <5c52ef1d0904212258r2ac2385bt963fc05593fb24f3@mail.gmail.com>
Date: 2009-04-22T05:58:53Z
From: XFM
Subject: how to?
In-Reply-To: <alpine.LFD.2.00.0904170959490.4596@gannet.stats.ox.ac.uk>
Hello,
I use windows XP, I have RGui with R version 2.8.1
I try to connect to a microsoft SQL database with is on a remote shared disk.
I have downloaded RODBC and DBI that I would like to use after if its simple.
For the moment I just try to connect with the DB, using
odbcConnect(dsn, uid = "", pwd = "", ...)
Actually I donnot understand what is dsn. The doc says
character string. A registered data source name.
But seriously it is not enough...
Whats that? The path to the DB?
I need a more detailed example than the one which is in the doc.
Thank you
xavier
On Fri, Apr 17, 2009 at 5:03 PM, Prof Brian Ripley
<ripley at stats.ox.ac.uk> wrote:
>
> On Fri, 17 Apr 2009, wrote:
>
>> Hello,
>>
>> I have downloaded R and I would like to do some sql queries. But I have
>> difficulties to find information. Do I need to download an additional
>
> Have you read the 'R Data Import/Export Manual' that is installed with R? ?That covers this.
>
>> package? And then, what is the procedure?
>
> All the information requested in the R posting guide is missing. ?We have no idea what platform you are using, what DBMS you are intending to use ....
>
> See http://www.r-project.org/posting-guide.html
>
>> Thank you very much for your help.
>>
>> Xavier
>>
>> ? ? ? ?[[alternative HTML version deleted]]
>
> Please also note that the R posting guide asked you not to send HTML mail.
>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB at stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>
> --
> 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