Microsoft SQL Server and R
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.