Page 1 of 1
Executing a stored procedure
Posted: Wed Aug 18, 2010 4:52 am
by Terry_(Guest)
The report executes a stored procedure and works ok when run directly in R&R. When the report is called from our application it returns an error message __DB Access: The connection statement or query handle you provided is not valid.__All other reports using views or tables work without any problem.__Any clues would be welcome
=> RE: Executing a stored procedure
Posted: Tue Aug 24, 2010 11:24 am
by rboatright
sql or xbase? where is the stored procedure stored? ____
==> RE: Executing a stored procedure
Posted: Wed Aug 25, 2010 7:32 am
by Terry_(Guest)
The procedure is stored in MSSQL2005
===> RE: Executing a stored procedure
Posted: Fri Aug 27, 2010 7:45 pm
by kfleming
What happens if you run rswrun.exe and manually select the report?____Kathleen__R&R Support
====> RE: Executing a stored procedure
Posted: Tue Aug 31, 2010 8:38 am
by Terry_(Guest)
Runs ok drectly from rwsrun.exe__Terry