[R] [RODBC] ERROR: Could not SQLExecDirect

From: Peter Eiger <Peter.Eiger_at_gmx.net>
Date: Wed 26 Jul 2006 - 05:50:52 EST


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 ...

R-help@stat.math.ethz.ch mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed Jul 26 05:55:58 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 27 Jul 2006 - 00:16:45 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.