Message-ID: <4418453B.5070205@juttastange.de>
Date: 2006-03-15T16:47:55Z
From: Hendrik Stange
Subject: RODBC with an Oracle DBS
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