[R-sig-DB] RODBC on Oracle DB

[Prof Brian Ripley]

The problem could be quoting, if Oracle is not standards-compliant.
See the options in ?odbcConnect.

If sqlQuery(essai, "select * from S_TYP_COLLEGES") works, this is likely 
to be the problem.

On Mon, 16 Jul 2007, eric using net2000.ch wrote:

>
>
>> 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
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595