I was trying to call iSeries stored procedure from Crystal Report 9 using ODBC connection and I hit ‘Statement violates access ruleIs’ error. I tried change AllowProcCalls=1 but it did not help (may be because I did not find my iSeries ODBC DSN.)
I then created new Crystal connection using Ole DB (Ado), it works!
Please note: I am using IBM DB2 UDB for iSeries OLE DB Provider, which I believe was installed together with Client Access.
After selecting IBM DB2 UDB for iSeries OLD DB Provider, a window ‘OLE DB(ADO) Connection Information’ will pop up, you have to enter the iSeries IP address at ‘Data Source’ and valid iSeries user ID/password. You can then click on the drop dwon botton to display the DATABASE name.