Associated statement is not prepared ???

[davidku]

Hi ...

I got a job using Web Publishing to generate report based on the data returned from store procedure. Lately, I got some funny problem which never happen before.

*************
Error Message
*************
SQL Web Assistant: Could not execute the SQL statement. [SQLSTATE 42000] (Error 16805) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed.

After I got an alert, I used SQL Query Analyser to run the same store procedure. It works okay.

Anyone know what happen and what I should do in order to get it work ?

Thanks in advance ...

 

[KrisSimonis]

The error probably isn't in the sp, it's in your web assistant or whatever program fires the statement that executes your sp. Try looking there.


Kris Simonis
Topdesk Information Systems,
Application Server Development

"You haven't seen the last of Meeaaaarrrrghh!!!"
- Several bad guys in several bad movies

 

[sexydog]

hi

Did anyone find out why this error message comes..Because i get this message sometimes when i use a stored proc in crystal reports