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

[¨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 using 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 using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>