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.