Crystal Report : Database Error !

[netizen]

Hi!
I'm using Crystal Reports 8.5 and DB2 to generate my reports. I've created an SP in AS/400 and am able to see that from Crystal Reports when i connect using the Data Explorer. But when i try to add teh SP to the report it gives me the following error:

"ODBC Error: [IBM][Client Access Express ODBC Driver (32bit)]Statement violates access rule:Connection is set to read only."

But the same will not be the case if i add the As/400 table! What is the problem here? Please let me know if anybody has any valuable idea/suggestion.

Thanks,
netizen

 

[synapsevampire]

It sounds like either the ODBC connection needs to have a setting adjusted (check the ODBC driver configuration), or perhaps the SP is doing more than just reading and the user executing the SP doesn't have rights.

-k