[R] ODBC & sqlSave

[C. Schulz]

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._