ODBC Error

[bessebo]

I am getting the following error when I try using a stored procedure to gather data for a report when I run it in the Report Designer:

ODBC error: Connection is busy with results from another hstmt.

Let me give you a little history on this report. The report format had already been created and it used a number of tables fields on the report. I realized after the fact that I really had to write code (stored procedure) to gather the proper data but i still wanted to use the same report format. So I used the Set Location option and I pointed each table to the stored procedure. I have done this before and it has worked but now I'm getting the above message. Any help?

Regards,
bessebo

 

[synapsevampire]

I always redo the report and copy and paste in the formulas, etc. because your tables have joins, which you cannot do with SP's (OK, I've managed to join an SP before, but you shouldn't).

Perhaps if you break the joins first, then try to use a set location, and set each table to the SP...

I'd rather base it on the SP to begin with to avoid any unforeseen results.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com