how to?

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

how to?

Thread (8 messages)