Microsoft SQL Server and R

3 messages · David Scott, Jim Porzak, Seeliger.Curt at epamail.epa.gov

Original

1

3

David Scott

Mon, Jan 25, 2010 2:55 PM #

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

Jim Porzak

Mon, Jan 25, 2010 3:32 PM #

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:

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

Seeliger.Curt at epamail.epa.gov

Mon, Jan 25, 2010 3:55 PM #

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100125/31bbef6d/attachment.pl>