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

[Joe O]

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.