Re: RODBC - problems connecting to oracle through linux

I've had a good experience with the ROracle driver.  Any reason why
you need RODBC?

-Whit

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:
>
>> 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 ...
>>