Problem
> library(RODBC) > ch <- odbcConnect("jcgi")Cannot output the result > sqlQuery(ch,"select sysdate from dual") Error in .Call(C_RODBCFetchRows, attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowedwith 32bit oracle library> library(RODBC) > ch <- odbcConnect("jcgi") Warning messages: 1: In odbcDriverConnect("DSN=jcgi") : [RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/11.2/client/lib/libsqora.so.11.1' : /usr/lib/oracle/11.2/client/lib/libsqora.so.11.1: wrong ELF class: ELFCLASS32 2: In odbcDriverConnect("DSN=jcgi") : ODBC connection failed
Solution
Add the option 'believeNRows = FALSE' in your odbcConnect() call. This option needs to be set when importing data from Oracle databases.
