[R-sig-DB] RODBC on Oracle DB

[eric m@iii@g oii @et2000@ch]

> essai <- odbcConnect("ORESTE_prod",  uid="****",  pwd="******" )
> odbcGetInfo(essai)
       DBMS_Name         DBMS_Ver  Driver_ODBC_Ver 
        "Oracle"     "09.00.0121"          "03.51" 
Data_Source_Name      Driver_Name       Driver_Ver 
   "ORESTE_prod"    "SQORA32.DLL"     "09.00.0101" 
        ODBC_Ver      Server_Name 
    "03.52.0000"           "weba" 


> sqlTables(essai)  

The result of this function is a liste of tables, one of them is called:
S_TYP_COLLEGES.


> sqlFetch(essai,"S_TYP_COLLEGES")
[1] "[RODBC] ERROR: Could not SQLExecDirect"                            
[2] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: Table ou vue inexistante\n"

> sqlFetch(essai, "S_TYP_COLLEGES", colnames=TRUE, rownames=FALSE)
[1] "[RODBC] ERROR: Could not SQLExecDirect"                            
[2] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: Table ou vue inexistante\n"


What could be the problem here ? 
Any help is welcome
Eric Röthlisberger, Neuchâtel