title: Querying Oracle DB from Revolution R using RODBC
body: <p>RODBC error in Revolution R 64bit on winxp64 bit connected to Oracle using a 64bit ODBC driver thru a DSN</p>
  
  <pre><code>library(RODBC)
  db &lt;- odbcConnect("oraclemiso",uid="epicedf",pwd="…")
  rslts = sqlQuery(db, "select count(*) from FTRAuction")
  
  Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize,  : 
    negative length vectors are not allowed
  </code></pre>
  
  <p>I am able to connect but get an error when I query for stuff,
  also the below works </p>
  
  <pre><code> library(RODBC)
   channel &lt;- odbcConnect("OraLSH", &lt;user&gt;, &lt;password&gt;))
   odbcQuery (channel, "select sysdate from dual")
   sqlGetResults(channel, as.is=FALSE, errors=FALSE, max=1, buffsize=1,
  nullstring=NA, na.strings="NA", believeNRows=TRUE, dec=getOption("dec"))
                SYSDATE
  1 2010-01-24 15:10:02
  </code></pre>
  
  <p>but what if I dont know the rowsize(max=1) before hand</p>
  
  <p>Thanks,
  Arun</p>