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