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

2014-06-06 Thread marcos.takahashi
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

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

2014-06-06 Thread Jeff Newmiller
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 NewmillerThe . .

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

2014-06-06 Thread David Winsemius
On Jun 6, 2014, at 8:45 AM, Jeff Newmiller wrote: 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. But what ever would be the correct answer, it should not segfault. I'm reasonable

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

2014-06-06 Thread marcos.takahashi
Oh, forgot telling the specifications: R version 3.0.2 (2013-09-25) Platform: x86_64-pc-linux-gnu (64-bit) Database: Mysql ODBC Connector: libmyodbc I've configured ODBC Connection using this hot-to: https://help.ubuntu.com/community/ODBC -- View this message in context: