[R] Linking R with Microsoft SQL Server / Client

[ONKELINX, Thierry]

Dear Steve,

Reading the data shouldn't be a problem with RODBC. I've been doing that
plenty of times. I'm not sure about writing, but I suppose you probably
will.

Cheers,

Thierry

------------------------------------------------------------------------
----

ir. Thierry Onkelinx

Instituut voor natuur- en bosonderzoek / Reseach Institute for Nature
and Forest

Cel biometrie, methodologie en kwaliteitszorg / Section biometrics,
methodology and quality assurance

Gaverstraat 4

9500 Geraardsbergen

Belgium

tel. + 32 54/436 185

Thierry.Onkelinx op inbo.be

www.inbo.be 

 

Do not put your faith in what statistics say until you have carefully
considered what they do not say.  ~William W. Watt

A statistical analysis, properly conducted, is a delicate dissection of
uncertainties, a surgery of suppositions. ~M.J.Moroney


-----Oorspronkelijk bericht-----
Van: r-help-bounces op stat.math.ethz.ch
[mailto:r-help-bounces op stat.math.ethz.ch] Namens Steve Friedman
Verzonden: maandag 12 februari 2007 15:15
Aan: r-help op stat.math.ethz.ch
Onderwerp: [R] Linking R with Microsoft SQL Server / Client

Hello

My colleagues and I have recently established a large database (40
tables
each with greater than 15 variables) in Microsoft's SQL Server 2000.
Currently we are accessing this database via SQL client running an
Windows
XP.   Our objectives are many fold including running SQL applications,
outputting results to ARC/INFO IMS, production of summarizing tables -
graphs and web interfaces for user accessibility.

The project is still very much in a design phase.  I'm interested in
knowing
if we can link R directly to the database  as it is either stored in SQL
Server, or SQL Client, or if we are better off keeping it simple and
extracting ascii (csv)  files from SQL server prior to processing
summarizing and model development.

Any insight provided will be greatly appreciated.

Steve

-- 
Steve Friedman
Computational Ecology and Visualization Laboratory
Michigan State University

Envisioning Ecosystem Decisions

	[[alternative HTML version deleted]]

______________________________________________
R-help op stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.