R help - Feb 2011 - Problem with RODBC sqlSave

Hi,

I'm able to establish a successful odbc connection using RODBC 1.3-2 on Win
7 and R 2.12.0. But I'm getting the following error message when I try to
save a data frame into the debase as shown below.

library(RODBC)
bbdb <- odbcConnect("bbdb")
odbcGetInfo(bbdb) # returns ok
sqlSave(bbdb, USArrests, rownames = "state", addPK=TRUE) #  example
from the
RODBC manual

Error in sqlSave(bbdb, USArrests, rownames = "state", addPK = TRUE) :
  [RODBC] ERROR: Could not SQLExecDirect 'CREATE TABLE "USArrests"
("state"
varchar(255) NOT NULL PRIMARY KEY, "Murder" double,
"Assault" integer,
"UrbanPop" integer, "Rape" double)'

Thanks in advance,
Lars.

	[[alternative HTML version deleted]]