Re: [R] RODBC - problems connecting to oracle through linux

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Mon, 01 Dec 2008 15:17:02 +0000 (GMT)

On Fri, 28 Nov 2008, Simon Collins wrote:

> Hi
>
> 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
>
>> library(RODBC)
>> setwd (paste("/home/oracle/scripts/R"))
>> channel <- odbcConnect("test", uid="prod", pwd="passwd")
>
> *** caught segfault ***
> address (nil), cause 'memory not mapped'
>
> Traceback:
> 1: .Call(C_RODBCDriverConnect, as.character(connection), id,
> as.integer(believeNRows))
> 2: odbcDriverConnect(st, ...)
> 3: odbcConnect("test", uid = "prod", pwd = "passwd")
> aborting ...
>
> The below shows the changes in the odbcinst.ini file.
>
>
> [ORACLE]
> 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)
>
> Cheers
>
> Simon
>
> Dr S J Collins
> Grid data consultant
> University Manchester
>
> ______________________________________________
> R-help_at_r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> 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
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Mon 01 Dec 2008 - 15:21:02 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 04 Dec 2008 - 19:31:09 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive