[R] RODBC and Oracle: error "table does not exist"

RINNER Heinrich H.RINNER at tirol.gv.at
Mon Jul 21 08:53:14 CEST 2003

I am re-trying a question I asked 12 days ago, to which unfortunately I got
no answer so far. Maybe someone who has succesfully established ODBC
connections between R and Oracle can give a hint what I am doing wrong?

-----Ursprüngliche Nachricht-----
Von: RINNER Heinrich [mailto:H.RINNER at tirol.gv.at] 
Gesendet: Mittwoch, 09. Juli 2003 15:34
An: 'r-help at stat.math.ethz.ch'
Betreff: [R] RODBC and Oracle: error "table does not exist"

Dear r-helpers!

I have trouble reading data from an Oracle data base using
RODBC Version 1.0-3,
R Version 1.7.1,
Windows XP,
Oracle8 ODBC Driver Version

> library(RODBC)
> channel <- odbcConnect(dsn="PAV32", case="oracle", believeNRows=FALSE)
> # ok, this was succesful
> x <- sqlTables(channel)
> x[37, ]
37        <NA>         TKF ABTGRNAMEN      TABLE    <NA>

> # ok, so the table I am looking for ("ABTGRNAMEN") is there, but:
> sqlFetch(channel, "ABTGRNAMEN")
[1] "[RODBC] ERROR: Could not SQLExecute"                                   
[2] "S0002 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not exist\n"
> # I also tried:
> sqlFetch(channel, "TKF.ABTGRNAMEN")
Error in odbcTableExists(channel, sqtable) : 
        TKF.ABTGRNAMEN : table not found on channel

What am I doing wrong here?
It doesn't work with other tables as well; on the other hand, connecting to
the table(s) in MS Access works fine using the same ODBC driver.

Best regards,

R-help at stat.math.ethz.ch mailing list

More information about the R-help mailing list