[R] RODBC problems

[Prof Brian Ripley]

On Mon, 12 Mar 2001, Stefano wrote:

>
>
> I think you have a line length problem somewhere in the interfaces.
>
> >There is another option to sqlSave (fast=FALSE from memory) that you could
> >try, but why do you want 524 columns in a single table?  You could
> >export them in parts and merge them in the DBMS,
>
> The first option doesn't work.
> So I tried splitting the dataframe in 3440x100. Ok the first four. The last one ( dat5 <- totale[,401:524] ) gives me:
>
> Error in sqlColumns(channel, tablename) : dat5 :table not found on channel 0
>
> Uhm, strange behaviour isn't it?

Well, MySQL is known to have a low-quality ODBC driver ...

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272860 (secr)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

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