Re: [R] RODBC and ORACLE

2012-11-13 Thread mmgm
Follow up. After lots of hours around this i got a fix: 1) Deinstalled Java 2) Downloaded the R Source 3) Configured ". oraenv" 4) Made sure the libsqora.so.11.1 was on the LD_LIBRARY_PATH 5) compiled from the source with the standard ./configure and make make install After this RODBC started

Re: [R] RODBC and Oracle

2009-07-30 Thread Edi Bice
I just joined and though I did quickly read the posting guide it is quite possible not going to be a perfect posting. For one I tried to figure out how to reply to an existing message on the topic. I gave up but figured I keep at least the same subject. In a gist I get an empty data frame after

Re: [R] RODBC and Oracle

2007-10-01 Thread Thomas Harte
l you find that Oracle buffer thingy.) the client that you used (PL/SQL) is probably not connecting to the database via ODBC, so you're not comparing apples with apples. cheers, thomas. > Message: 82 > Date: Fri, 28 Sep 2007 17:26:24 -0700 (PDT) > From: John McHenry <[EMAIL PROT

[R] RODBC and Oracle

2007-09-28 Thread John McHenry
Hi WizaRds, I'm experiencing a problem connecting to an Oracle 10g database via RODBC (I'm getting this on Microsoft XP). The same SQL queries via PL/SQL Developer work just fine, but when I pump the query through sqlQuery in RODBC then I get a data frame back with 0 rows. I cut the query down