[R-sig-DB] how to?

[XFM]

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 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