[R-sig-DB] how to?

[Prof Brian Ripley]

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 using 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 using stat.math.ethz.ch
>>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>>
>>
>> --
>> Brian D. Ripley,                  ripley using 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 using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using 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