[R] RODBC results from stored procedure

[tradenet]

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.