Thanks Dieter. The date argument isn't a problem. When I invoke the stored proc execution with the date arguments the stored proc runs fine, but RODBC doesn't wait for the stored proc to finish and return results.
Regards, Andrew Dieter Menne wrote: > > > > 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-tp24503096p24576806.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.