Re: [R] Reading SQL Server Tables using RODBC

2010-12-09 Thread pfruin
Paul Miller wrote: > > Hello Everyone, >   > I'm still quite new to R and am having trouble reading SQL Server Tables > using RODBC. I've looked though the RODBC documentation as well as > material I found online and in the book "Data Manipulation with R," but I > just can't quite seem to get th

Re: [R] Reading SQL Server Tables using RODBC

2010-03-25 Thread Marc Schwartz
On Mar 25, 2010, at 11:46 AM, Paul Miller wrote: > Hello Everyone, > > I'm still quite new to R and am having trouble reading SQL Server Tables > using RODBC. I've looked though the RODBC documentation as well as material I > found online and in the book "Data Manipulation with R," but I just

Re: [R] Reading SQL Server Tables using RODBC

2010-03-25 Thread Bos, Roger
Paul, I have never tried odbcDriverConnect, but I can tell you how I connect to my SQL Server 2005 db. I create a DNS entry using "odbcad32" (use start>run). You can specify everything there and test the connection. Once that tests okay, just use the following: library(RODBC) xf <- odbcConn