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]]

