[R] RODBC - problems connecting to oracle through linux

Simon Collins Simon.Collins-2 at manchester.ac.uk
Fri Nov 28 23:09:15 CET 2008


I'm presently trying to connect to Oracle through RODBC / UnixODBC on  
linux (Red Hat 5). I've successfully connected through the easysoft  
drivers but the trial license has run out and I'm trying to connect  
via the default Oracle 11G driver. However I'm getting the following  

> library(RODBC)
> setwd (paste("/home/oracle/scripts/R"))
> channel <- odbcConnect("test", uid="prod", pwd="passwd")

  *** caught segfault ***
address (nil), cause 'memory not mapped'

  1: .Call(C_RODBCDriverConnect, as.character(connection), id,  
  2: odbcDriverConnect(st, ...)
  3: odbcConnect("test", uid = "prod", pwd = "passwd")
aborting ...

The below shows the changes in the odbcinst.ini file.

Description             = Easysoft ODBC Oracle Driver
#Driver         = /usr/local/easysoft/oracle/libesoracle.so
Driver          = /u01/app/oracle/product/11.1.0/db_1/lib/libsqora.so.11.1
#Setup          = /usr/local/easysoft/oracle/libesoraclesetup.so
DontDLClose             = 1
FileUsage               = 2

Can anyone point me to what I'm doing wrong?

Version of R = R version 2.8.0 (2008-10-20)



Dr S J Collins
Grid data consultant
University Manchester

More information about the R-help mailing list