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

[R] Reading SQL Server Tables using RODBC (Got it!)

2010-03-25 Thread Paul Miller
Thanks to those who responded to my post about reading SQL server tables using RODBC. Someone in our IT department sent me a link that contained the following information:   SQL ODBC connection strings Standard Security:< br> "Driver={SQLServer};Server=Your_Server_Name;Database= Your_Database_Na

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
ary(RODBC) xf <- odbcConnect("dns entry name", "sql username", "sql user password") HTH, Roger -Original Message- From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of Paul Miller Sent: Thursday, March 25, 2010 12:47 PM To: r-help

[R] Reading SQL Server Tables using RODBC

2010-03-25 Thread Paul Miller
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 things to work.   Right now, I have