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