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

2003-07-21 Thread RINNER Heinrich
] Gesendet: Mittwoch, 09. Juli 2003 15:34 An: '[EMAIL PROTECTED]' 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 8.1.6.4.0: library

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

2003-07-21 Thread RINNER Heinrich
:[EMAIL PROTECTED] Gesendet: Montag, 21. Juli 2003 09:11 An: 'RINNER Heinrich' Betreff: RE: [R] RODBC and Oracle: error table does not exist hallo, I'm using following syntax: which is working fine (with Oracle 8.1.7.2): channel - sh3 - sqlQuery(channel, select

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

2003-07-09 Thread RINNER Heinrich
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 8.1.6.4.0: library(RODBC) channel - odbcConnect(dsn=PAV32, case=oracle, believeNRows=FALSE) # ok, this was succesful x - sqlTables(channel)