[R-sig-DB] RODBC with an Oracle DBS

[Hendrik Stange]

Hello,

today, I tried saving a data.frame to Oracle by using an ODBC-connection.
It failed every single time, giving me a "missing column name" error.
Reading works perfectly fine, though.

My question is, how can I upload a df to Oracle using an ODBC connection?

The code I used looks like this:
channel <- odbcConnect("someODBCname")
sqlSave(channel, df, tablename="test", rownames=FALSE, addPK=T, verbose=T)

df is a 100x100 matrix; dimnames are set.

In my desperation I tried uploading it to MS-Access and it worked 
absolutely accurate - same statement just another ODBC-connector name.

I'd appreciate any help.

Thanks in advanced,
H. Stange