[R] RODBC sqlSave Error

[ripley@stats.ox.ac.uk]

The error is quite clear: the SQLexecute command failed.  That's not an R 
error, but an SQL error, so ask your DBMS helpline.  For example, does
whatever DBMS this is support German labels?  Does it support table names 
like mno.x?  Do you have permissions to create tables? ....

On Wed, 29 Jan 2003, Christian Schulz wrote:

> Hi,
> 
> i get error after using a data.frame with subset  for "sqlSave".
> What can i do ?
> 
> It seems that  lines like this in a data.frame structure are after subset
> deleted and cause
> the error ?
> 
>  - attr(*, "variable.labels")= Named chr  "CUSID" "Welle"
> "Arbeitgeberfavorit1" "Aktuelle Bewerbungssituation" ...
>   ..- attr(*, "names")= chr  "CUSID" "WELLE" "Q21" "BEWERB" ...
> 
> sqlSave(channel,mno.x,verbose=T)
> Query: CREATE TABLE mno.x  (rownames varchar(255)  ,BEWERB double
> ,MEDIENPRÄSENZ double  ,GESCHLECHT double  )
> Error in sqlSave(channel, mno.x, verbose = T) :
>         [RODBC] ERROR: Could not SQLExecute
> >>str(mno.x)
> `data.frame':   583 obs. of  3 variables:
>  $ BEWERB       : num  2 2 1 2 1 1 2 2 1 1 ...
>  $ MEDIENPRÄSENZ: num   73.3  75.0  70.0  60.0 100.0 ...
>  $ GESCHLECHT   : num  1 1 1 1 1 1 1 1 1 1 ...
> 
> 
> { RODBC-1-0-1,R-1.6.2,W2k }
> 
> many thanks, christian
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help
> 

-- 
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 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595