[R-sig-DB] In odbcDriverConnect ODBC connection failed

[Thomas Liebig]

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 using iais.fraunhofer.de
Phone:  +49 2241 142050
Fax:    +49 2241 142072