Message-ID: <alpine.LFD.2.00.0904220733190.2871@gannet.stats.ox.ac.uk>
Date: 2009-04-22T06:35:04Z
From: Brian Ripley
Subject: how to?
In-Reply-To: <5c52ef1d0904212258r2ac2385bt963fc05593fb24f3@mail.gmail.com>
On Wed, 22 Apr 2009, XFM wrote:
> 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...
If you are using ODBC, it is. Did you read the README in the package?
And you ODBC documentation?
> Whats that? The path to the DB?
> I need a more detailed example than the one which is in the doc.
Like the ones in the installed tests.R file?
> 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
>
> _______________________________________________
> 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