Displaying 2 results from an estimated 2 matches for "mysqlodbc".
2012 Feb 06
0
sqsSave() test using Test.R script returning error suggesting no values upon "insert"
...d package RODBC folder.
Beginning with the following:
library(RODBC)
library(MASS)
USArrests[1,2] <- NA
hills <- hills[1:15,]
row.names(hills)[12] <- "Dollar ('$')"
set.seed(1)
# MySQL
## testdb3 is ODBC/Connector 3.51.x, testdb5 is 5.1.x
channel <- odbcConnect("MysqlODBC") #my database
odbcGetInfo(channel)
sqlTypeInfo(channel)
sqlTables(channel)
sqlDrop(channel, "test.USArrests",errors = FALSE) #explicit database AND table call as MySQL doesn't allow general table creation
Everything works as advertised.
------------------------------------...
2011 Jul 17
1
ODBC MySql DB: sqlQuery empty
...d with "isql" and works [3].
If I connect from GNU R to the database, an empty list of tables is
presented and sqlQuery(t.con, "show databases") returns an empty list
[4].
What am I doing wrong I tried nearly everyting, but nothing seems to work.
Thanks,
Henri
---1: INSTALL mysqlOdbc libraries
$ wget http://dev.mysql.com/get/Downloads/Connector-ODBC/5.1/mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-64bit.tar.gz/from/http://ftp.gwdg.de/pub/misc/mysql/
$ tar xvzf mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-64bit.tar.gz
---2: unixODBC setup
$ more ~/.odbc.ini
[MySQL-data...