[R] RODBC crashes connecting to Teradata

[Prof Brian Ripley]

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