Just an update to this - it is possible to connect to an 11G database
via using the oracle 10G (libsqora.so.10.1) driver.
Quoting "Prof Brian Ripley" <[EMAIL PROTECTED]>:
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@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, [EMAIL PROTECTED]
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@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.
