[R] RODBC sqlSave Error

Christian Schulz ozric at web.de
Wed Jan 29 23:34:02 CET 2003


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




More information about the R-help mailing list