[R-sig-DB] RODBC and Oracle 11g Issue.....

[Marc Schwartz]

On Mar 5, 2010, at 9:18 AM, Joe O wrote:

> Marc - 
> 
> Thanks for the help. I tried your suggestion:
> 
> [ruser using vsrv05 ~]$ R
> 
> R version 2.10.0 (2009-10-26)
> Type 'q()' to quit R.
> 
>> library(RODBC)
>> channel <- odbcConnect("OracleLocal", uid="parts", pwd="parts",rows_at_time = 1)
>> sqlQuery(channel, "select distinct segment from parts", errors=TRUE,rows_at_time = 1)
> character(0)
>> sqlTables(channel)
>> 
> 
> ..and no joy. 
> 
> Has anyone gotten R running on 64 bit Linux to connect to Oracle 11g running on 64 bit Linux using the Linux unixODBC library and R RODBC library? Works fine on a 32 bit Windows environment.


OK....stoopid question time:

1. I presume that you installed the 64 bit version of Oracle's instant client and ODBC driver from:

   http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxx86_64soft.html


2. You are running a 64 bit version of R?  Check the output of .Machine$sizeof.pointer and be sure that it shows 8, not 4.


3. You are using a 64 bit version of unixODBC?


Just to be sure, since the entire tool chain needs to be 64 bit, although typically you might get a segfault or other problem when mixing 32/64 bit.


Also, just for the heck of it, can you post the output of:

  unclass(channel)


Lastly, try using 'case = "toupper"' in the odbcConnect() call to see if that makes any difference:

  channel <- odbcConnect("OracleLocal", uid="parts", pwd="parts", rows_at_time = 1, case = "toupper")


Marc