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
RODBC with an Oracle DBS
2 messages · Hendrik Stange, ¨Tariq Khan
Hendrik, can we see a sample of your column names? Seems like your code should work. what if safer=F?.. and if addPK=F? (not that I expect that to work). -Tariq
On 3/15/06, Hendrik Stange <hstange at juttastange.de> wrote:
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
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-db