[R] RODBC - address 0x407, cause 'memory not mapped'

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Fri Jun 6 17:45:09 CEST 2014

"con" is probably not a valid ODBC DSN. You need to study how ODBC works independently of R... we cannot tell you what you should be putting there instead.
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
Sent from my phone. Please excuse my brevity.

On June 6, 2014 5:56:12 AM PDT, "marcos.takahashi" <marcos.takahashi at mobly.com.br> wrote:
>Hi guys,
>I am running a simple R script using RODBC that follows:
>ch <- odbcConnect("con")
>cust<- sqlQuery(ch, "select
>    id_customer,
>    first_name
>    customers
>limit 100")
>sales<- sqlQuery(ch, "select
>    id_order,
>    revenue
>    sales
>limit 100")
>And it returns the following error:
> *** caught segfault ***
>address 0x407, cause 'memory not mapped'
>1: .Call(C_RODBCQuery, attr(channel, "handle_ptr"),
> 2: odbcQuery(channel, query, rows_at_time)
>3: sqlQuery(ch, "select\n    id_order,\n    revenue\nfrom\n   
>Possible actions:
>1: abort (with core dump, if enabled)
>2: normal R exit
>3: exit R without saving workspace
>4: exit R saving workspace
>Does somebody have any idea about this issue?
>View this message in context:
>Sent from the R help mailing list archive at Nabble.com.
>R-help at r-project.org mailing list
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list