[R] RODBC crashes connecting to Teradata

Prof Brian Ripley
2008-12-18T20:36:55Z

On Thu, 18 Dec 2008, Francisco Javier Perez Caballero wrote:

> Hi, I'm trying to connect to a Teradata database via RODBC on a Linux
64
> machine (Red Hat Enterprise Linux 5).  The ODBC driver is properly
> configured and queries sent via unixODBC's isql tool work properly.
However,
> this is what happens when I try to connect via RODBC:
>
>> library(RODBC)
>> conn = odbcConnect("thedsn", uid="theuid",
pwd="thepass")
>
> *** caught segfault ***
> address (nil), cause 'memory not mapped'
>
> Traceback:
> 1: .Call(C_RODBCGetInfo, attr(stat, "handle_ptr"))
> 2: odbcDriverConnect(st, ...)
> 3: odbcConnect("thedsn", uid = "theuid", pwd =
"thepass")
>
> Possible actions:
> 1: abort (with core dump, if enabled)
> 2: normal R exit
> 3: exit R without saving workspace
> 4: exit R saving workspace
>
> Any idea of what is going on here?

Most likely a broken driver.  It seems that several do not support GetInfo
correctly: isql does not use it by default.  Debugging will show you where
the error actually was.

And if you had done your homework you would have found that answer many
times (especially in the archives of  the appropriate list, R-sig-db).

>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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