[R] RODBC - problems connecting to oracle through linux
armstrong.whit at gmail.com
Mon Dec 1 16:44:41 CET 2008
I've had a good experience with the ROracle driver. Any reason why
you need RODBC?
On Mon, Dec 1, 2008 at 10:17 AM, Prof Brian Ripley
<ripley at stats.ox.ac.uk> wrote:
> On Fri, 28 Nov 2008, Simon Collins wrote:
>> 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 error
>>> 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?
> The short answer is no, but running under gdb and getting a backtrace will
> show what is going wrong.
> My experience suggestst that this is almost certainly a bug in the ODBC
> driver. (RODBC asks the driver for more info than most applications, and
> that often stresses badly written drivers.) So it is very likely that you
> are doing nothing wrong, but one of your tools is letting you down.
>> Version of R = R version 2.8.0 (2008-10-20)
>> Dr S J Collins
>> Grid data consultant
>> University Manchester
>> R-help at r-project.org mailing list
>> PLEASE do read the posting guide
>> and provide commented, minimal, self-contained, reproducible code.
> Brian D. Ripley, ripley at stats.ox.ac.uk
> Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/
> University of Oxford, Tel: +44 1865 272861 (self)
> 1 South Parks Road, +44 1865 272866 (PA)
> Oxford OX1 3TG, UK Fax: +44 1865 272595
> R-help at r-project.org mailing list
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help