Re: [R] Linking R with Microsoft SQL Server / Client

2007-02-12 Thread Bos, Roger
ames=FALSE) HTH, Roger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ONKELINX, Thierry Sent: Monday, February 12, 2007 9:36 AM To: Steve Friedman; r-help@stat.math.ethz.ch Subject: Re: [R] Linking R with Microsoft SQL Server / Client Dear Steve, R

Re: [R] Linking R with Microsoft SQL Server / Client

2007-02-12 Thread ONKELINX, Thierry
[mailto:[EMAIL PROTECTED] Namens Steve Friedman Verzonden: maandag 12 februari 2007 15:15 Aan: r-help@stat.math.ethz.ch Onderwerp: [R] Linking R with Microsoft SQL Server / Client Hello My colleagues and I have recently established a large database (40 tables each with greater than 15 variables) in

Re: [R] Linking R with Microsoft SQL Server / Client

2007-02-12 Thread Wensui Liu
steve, i think you can use R to link to sql server directly with RODBC. but it is not wise to dump the whole table from db into R and then do manipulation, which will slow the speed of R. On 2/12/07, Steve Friedman <[EMAIL PROTECTED]> wrote: > Hello > > My colleagues and I have recently establish

[R] Linking R with Microsoft SQL Server / Client

2007-02-12 Thread Steve Friedman
Hello My colleagues and I have recently established a large database (40 tables each with greater than 15 variables) in Microsoft's SQL Server 2000. Currently we are accessing this database via SQL client running an Windows XP. Our objectives are many fold including running SQL applications, out