"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:<jdnew...@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.takaha...@mobly.com.br> wrote: >Hi guys, > >I am running a simple R script using RODBC that follows: > >---- > >library(RODBC) >ch <- odbcConnect("con") > >cust<- sqlQuery(ch, "select > id_customer, > first_name >from > customers >limit 100") > >sales<- sqlQuery(ch, "select > id_order, > revenue >from > sales >limit 100") > >----- > >And it returns the following error: > > *** caught segfault *** >address 0x407, cause 'memory not mapped' > >Traceback: >1: .Call(C_RODBCQuery, attr(channel, "handle_ptr"), >as.character(query), >as.integer(rows_at_time)) > 2: odbcQuery(channel, query, rows_at_time) >3: sqlQuery(ch, "select\n id_order,\n revenue\nfrom\n >sales\nlimit >100") > >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: >http://r.789695.n4.nabble.com/RODBC-address-0x407-cause-memory-not-mapped-tp4691806.html >Sent from the R help mailing list archive at Nabble.com. > >______________________________________________ >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. ______________________________________________ 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.