From: jgaseff <jgaseff_at_gmail.com>
Date: Wed 24 Jan 2007 - 20:25:31 GMT


I am fairly new to R and its connectivity to MS-Access. I just installed RODBC and it seems to be working well except when I use the date to condition the query. For example the query below

sqlQuery(channel, "select date from tblUScpi where (date > d2) order by date")

returns the following error

[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "07001 -3010 [Microsoft][ODBC Microsoft Access Driver] Too few
parameters. Expected 1."

I checked that d2 and the elements in date belong to the same class ("POSIXt" "POSIXct"). Can anybody help me?

View this message in context: http://www.nabble.com/RODBC-tf3084357.html#a8571820
Sent from the R help mailing list archive at Nabble.com.

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 Thu Jan 25 15:43:10 2007

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 25 Jan 2007 - 05:30:29 GMT.

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