[R] RODBC results from stored procedure

[Dieter Menne]

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.