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 alternating between PL/SQL and RODBC until I figured
that it's some kind of row limit or buffer limit thing going on.
I searched the archives and Brian Ripley suggested playing with believeNRows
parameter (setting it to FALSE) as Oracle is not well behaved. I've tried
various
combinations of this and delving into the lower level functions like odbcQuery
and sqlGetResults but I'm still getting the same thing: 0 rows back unless
I cut the query down to a more return a more reasonable range.
Obviously I can't reproduce the problem here because of the database, but does
anyone have any suggestions/tips/pointers to get me going toward a solution?
Maybe it's a settings problem in the Microsoft ODBC thing under
Control Panel->Administrative Tools->Data Sources
Any suggestions on this?
All help gladly received.
Thanks!
Jack.
platform i386-pc-mingw32
arch i386
os mingw32
system i386, mingw32
status
major 2
minor 5.1
year 2007
month 06
day 27
svn rev 42083
language R
version.string R version 2.5.1 (2007-06-27)
---------------------------------
[[alternative HTML version deleted]]
______________________________________________
[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.
