opening crystal report using ISeries sql error Temp table already exists
I built an sql stored procedure on the ISeries using ISeries Navigator. The procdure returns a good result set using a couple of global temporary tables from other stored procedures I call. When I try to access the stored procedure using Crystal X1, I get an obdc error telling me the temp table already exists. I have even rebooted my PC and I still get the error. I have changed the connection pooling in the odbc connections box to allow and not alow connection pooling. My registry setting for the odbc connection has "AllowProcCalls" set to 1. Any help is greatly appreciated.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 29, 2007 8:20 PM
UPDATED:
December 13, 2007 10:24 PM
RELATED QUESTIONS
Answer Wiki:
Hi Jlav
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
