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.
October 29, 2007 8:20 PM
December 13, 2007 10:24 PM