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]]

