essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15"
,case="oracle")
> sqlTables(essai)$ORESTE
...
1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA>
1316 <NA> ORESTE S_PROVENANCES TABLE <NA>
1317 <NA> ORESTE S_SEXES TABLE <NA>
1318 <NA> ORESTE S_SOUS_CLASSES TABLE <NA>
1319 <NA> ORESTE S_TYP_COLLEGES TABLE <NA>
1320 <NA> ORESTE S_TYP_ENSEIGNEMENT TABLE <NA>
...
> sqlQuery(essai, "select * from S_TYP_COLLEGES")
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: Table ou vue inexistante\n"
I have also tried the
essai2 <- odbcDriverConnect(connection="essai2")
But with no succes.
On Lun Juil 16 15:32 , Prof Brian Ripley <[EMAIL PROTECTED]> sent:
>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, [EMAIL PROTECTED] wrote:
>
>>
>>
>>> essai
>>> 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
>> [EMAIL PROTECTED]
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>>
>
>--
>Brian D. Ripley, [EMAIL PROTECTED]
>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
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
