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

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 Business 
Server with 3mb of RAM.  I run gc() prior to attempting the query.  I 
have attempted to maximize the memory R uses by running the command 
"memory.size(4095)")

 After attempting my "odbcConnect" query, I receive the following error message:
  "Error: cannot allocate vector of size 522 Kb".

 After I received the message, I obtained the following statistics re my memory use:
  memory.limit(size = NA)/1000 #reports memory size
[1] 4.095

memory.size(max = F)/1000 #reports amount of memory currently in use

[1] 1.930705

memory.size(max = T)/1000 #reports maximum amount of memory obtained from the OS

[1] 1.93925

 Before I give up and go back to running many queries to extract my data, I wanted to ask if there were any suggestions. (I really do wish to extract all this data for local storage as R-files on my hard-drive, it is just a question of the easiest and fastest process.)  Thanks.




---------------------------------

	[[alternative HTML version deleted]]