Hello,
i have some courious habit when i use the odbcpackage with
(MS-Acces & MySql)!
(1)
channel <- odbcConnect("testdatabase", "", "")
sqlSave(channel, fuzzyframe, verbose = TRUE)
works fine !
X1 X2 X3
1 0.5903806 0.2706767 0.13894263
2 0.3771841 0.5257416 0.09707437
3 0.5152837 0.2907690 0.19394728
.........
(2)
channel <- odbcConnect("testdatabase", "", "")
sqlSave(channel, xdat, verbose = TRUE)
i get
Error in sqlColumns(channel, tablename) : xdat
:table not found on channel 1
and not surprising
i get the same error when i match the dataframes with cbind !
EXID Q110 Q120 Q130 Q210 Q220 Q230 Q240 Q250 Q610 Q640 Q650 ALTER
1 6 9 6 3 4 6 6 3 2 1 4 8 30
2 21 4 6 3 4 5 2 2 2 1 4 8 26
3 22 4 3 2 3 6 2 4 1 1 5 3 31
............
What is happen, both are dataframes and the (RODBC-Example) dataset
USArrests works well, too !????
Thanks in advance for a solution of the mystery habit!
Christian
______________________________________________________________________________
Flug.de - 570.000 Nutzer, ein Ziel: der optimale Flug
http://flug.de/sb/?PP=0-5-100-105-12
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at
stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._