[R] Microsoft SQL Server and R

[Jim Porzak]

David,

You can certainly use RODBC to get to MS SQL, once you configure the
ODBC connection in windows.

These days I tend to use RJDBC http://www.rforge.net/RJDBC/ which is a
bit less of a hassle.

Hint use the jtds driver http://jtds.sourceforge.net/

HTH,
Jim Porzak
Ancestry.com
San Francisco, CA
www.linkedin.com/in/jimporzak
use R! Group SF: www.meetup.com/R-Users/


On Mon, Jan 25, 2010 at 2:55 PM, David Scott <d.scott at auckland.ac.nz> wrote:
>
> I have a client running Microsoft SQL Server. I am interested in ways of  accessing data from this server using R.
>
> I would welcome any information about how this can be done. I have a reasonable grasp of SQL and have experience with MySQL and RODBC but don't know anything much about Microsoft SQL Server.
>
> David Scott
> --
> _________________________________________________________________
> David Scott     Department of Statistics
>                The University of Auckland, PB 92019
>                Auckland 1142,    NEW ZEALAND
> Phone: +64 9 923 5055, or +64 9 373 7599 ext 85055
> Email:  d.scott at auckland.ac.nz,  Fax: +64 9 373 7018
>
> Director of Consulting, Department of Statistics
>
> ______________________________________________
> R-help at r-project.org 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.