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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
