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

Luis Ridao Cruz luisr at hav.fo
Wed Aug 12 14:23:17 CEST 2009


R-sig-Debian 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



More information about the R-SIG-Debian mailing list