[R] RODBC/Solaris/Oracle - No Data

[loganp@post.ch]

Hi,

Version info:
R: 1.5.1
RODBC: 0.8.3
Oracle: 8.1.7
unixODBC: 2.2.2
Easysoft ODBC driver: 1.0.0.6
SunOS/Solaris: 5.7

I'm trying to get RODBC working with Oracle on Solaris. I've installed unixODBC and the Easysoft ODBC driver. There are no problems connecting to the DB and executing queries using unixODBC's isql interactive client. Using R and RODBC however, I can open a connection but whenever I execute queries, I simply recieve a "No Data" message.

Debugging a query such as "select * from sometable", on the R side of things I receive the column names OK but when it calls down to RODBCFetchRows, the following object gets returned into erg, which in turn gets assigned to dbdata in sqlGetResults.

Browse[1]> dbdata
$data
$data[[1]]
NULL


$stat
[1] -1

I have executed the same query via unixODBC's isql using the same DSN and I receive a full result set with several rows.

Any suggestions please?

Thanks very much,
Phil
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._