[R] R to Oracle via RODBC

[Vikram Khurana]

Howdy,

I'm trying to use R to access Oracle 8i using the RODBC package On Linux 
Red Hat 7.3.
Specs
R version 1.51
Driver: Easysoft ODBC - Oracle driver
Driver Manager: unixODBC

I get the following error when trying to executing RODBC commands. Can 
anybody give me pointers as to what I'm missing or doing wrong

 > library(RODBC)
 > channel <- ("DSNName")
 > sqlQuery(channel,"select * from tableX")
Error in odbcQuery(channel, query) : NAs in foreign function call (arg 1)
In addition: Warning message:
NAs introduced by coercion
 > odbcTables(channel)
Error in odbcTables(channel) : NAs in foreign function call (arg 1)
In addition: Warning message:
NAs introduced by coercion

I am successfully able to run queries on the Oracle 8i database using 
Oracle SqlPlus and also using Easysoft's isql(which uses the odbc.ini file)

The .odbc.ini file in the root folder looks as follows:

[DSNName]
Driver        = ORACLE
Database        = ServerName
User        = userName
Password        = pwd
METADATA_ID        = 0
ENABLE_USER_CATALOG        = 1
ENABLE_SYNONYMS        = 1

Any help is very appreciated!!

Vikram


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