tradenet wrote:
>
> Short of uploading a SQL server database, I don't think I can make this
> example reproducible, but I hope it's not so complicated as to require
> reproducibility....
>
> I can call a parametrized stored procedure without a problem and the proc
> does indeed execute successfully.
>
This works for me with the popular Northwind database
channel = odbcConnect("northwind") # Assume this is configured correctly
sqlQuery(channel,"EXEC CustOrderHist @CustomerID=ALFKI")
Try with a non-date query first, the switch to the tricky date format in the
parameter.
Dieter
--
View this message in context:
http://www.nabble.com/RODBC-results-from-stored-procedure-tp24503096p24503854.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
