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
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 . .
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
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:
4 matches
Mail list logo