Re: [R] RODBC, optimizing memory, "Error: cannot allocate vector of size 522 Kb".

2007-12-13 Thread Prof Brian Ripley
This question is nothing to do with RODBC. You need to study the rw-FAQ Q2.9: I believe you should be able to get up to (almost) 3GB on that system. (BTW, you seem confused about units: I hope you have 3GB of RAM, where G means 1024^3.) On Thu, 13 Dec 2007, Thomas Pujol wrote: > I am using R

[R] RODBC, optimizing memory, "Error: cannot allocate vector of size 522 Kb".

2007-12-13 Thread Thomas Pujol
I am using RODBC and "odbcConnect". I have successfully used odbcConnect to extract "modest" amounts of data from SQL. For convenience, (and maybe speed?) I wish, if possible, to extract larger amounts of data in a single query. (I am running R2.6.0 under a machine running Windows Small B