Executing a stored procedure

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Terry_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

Executing a stored procedure

Post by Terry_(Guest) » Wed Aug 18, 2010 4:52 am

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
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Executing a stored procedure

Post by rboatright » Tue Aug 24, 2010 11:24 am

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

Terry_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Executing a stored procedure

Post by Terry_(Guest) » Wed Aug 25, 2010 7:32 am

The procedure is stored in MSSQL2005

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

===> RE: Executing a stored procedure

Post by kfleming » Fri Aug 27, 2010 7:45 pm

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

Terry_(Guest)
Posts: 10
Joined: Tue Oct 10, 2017 12:44 pm

====> RE: Executing a stored procedure

Post by Terry_(Guest) » Tue Aug 31, 2010 8:38 am

Runs ok drectly from rwsrun.exe__Terry

Post Reply