Hi Luis, I also use RODBC to connect an ORACLE DB. This is implemented using the following statements require(RODBC) con<-odbcConnect(DB$name,DB$user,DB$pass,case="tolower",believeNRows=FALSE) res<-sqlQuery(con,"select 'test' from dual") odbcClose(con) To test your unixodbc installation you should ask google, there are some linux tools to test your configuration. regards, Thomas Luis Ridao Cruz schrieb:
R-sig-DB help, I have installed an ODBC Driver for Linux. I want to connect to our database through R via:
library(RODBC)
con <- odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS")
Warning message:
In odbcDriverConnect("SERVER=IP_address:PORT;DRIVER=ORACLE;DATABASE=MAGNUS") :
ODBC connection failed
I don't really know whether this is the right syntax. I copy-paste files "odbc.ini" and "odbcinst.ini":
## file odbc.ini
[ORACLE]
Driver = ORACLE
Database = //IP_address:PORT/MAGNUS
User = my_username
Password = my_password
METADATA_ID = 0
ENABLE_USER_CATALOG = 1
ENABLE_SYNONYMS = 1
## file odbcinst.ini
[ORACLE]
Description = Easysoft ODBC Oracle Driver
Driver = /usr/local/easysoft/oracle/libesoracle.so
Setup = /usr/local/easysoft/oracle/libesoraclesetup.so
DontDLClose = 1
FileUsage = 1
UsageCount = 1
Thanks in advance
Thomas Liebig Fraunhofer-Institut f?r Intelligente Analyse- und Informationssysteme (IAIS) Schloss Birlinghoven, D-53754 Sankt Augustin, Germany Email: thomas.liebig at iais.fraunhofer.de Phone: +49 2241 142050 Fax: +49 2241 142072