[R] [RODBC] ERROR: Could not SQLExecDirect

Peter Eiger Peter.Eiger at gmx.net
Tue Jul 25 21:50:52 CEST 2006


I've got a problem with RODBC and saving (sqlSave) of a dataframe in Access.
R 2.0.1 is running on windows XP.

When executing the examples in R help for the "USArrests" data set "sqlSAve" works fine, but running sqlSave() for a dataframe "Adat" 

> str(Adat)
`data.frame':   1202 obs. of  18 variables: 

containing 18 columns and ca. 1200 rows fails.

I get the following error message:

> sqlSave(channel, Adat)
Error in sqlSave(channel, Adat) : [RODBC] ERROR: Could not SQLExecDirect

The data was fetched from the same Access database before and was not manipulated before the attempt to save.
What's wrong?

Any advice is welcome!


"Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ...

More information about the R-help mailing list