Executing a stored procedure

[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

[rboatright]

sql or xbase? where is the stored procedure stored? ____

[Terry_(Guest)]

The procedure is stored in MSSQL2005

[kfleming]

What happens if you run rswrun.exe and manually select the report?____Kathleen__R&R Support

[Terry_(Guest)]

Runs ok drectly from rwsrun.exe__Terry