opening crystal report using ISeries sql error Temp table already exists

pts.
Tags:
Crystal Reports
iSeries
ODBC
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following