[R] RODBC problems

[Stefano]

Hi all.

I'm trying to see how the package Rodbc works, with R 1.2.2, win98 and MySql 3.23.
I'd like to export a dataset with 524 variables and 3440 records form R to MySql. I issued the following commands:

library(RODBC)
channel <- odbcConnect("test")
sqlSave(channel,dat=totale)

Error in sqlTables(channel)[, 3] : incorrect number of dimensions

Actually it gave me other error messages, in previous trials *with the same commands*.
Once it said something like ... vector maximum memory size reached...
Another time something like ...sqlColumns(...??)  c(30,2,30...) should be a vector names  
                                                                         ^^^^^^^^^^^^^
                                                         (these are the values in the first variable)

To reduce the load I created a 1x524 dataframe (to create the table structure and then importing tha data directly from file.csv to MySql), but still I got the same error

Where do I go wrong and why it gives different error messages with the same command?

Thank you,

Stefano

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