Connecting to Stored Procedure from Crystal

[Keith]

I am trying to connect to a DB2 database using "iSeries Access ODBC
Driver" from Crystal Reports. I am able to report on tables and queries
but not stored procedures. I get the following error after I select the
procedure and enter the parameter.

Query Engine Error: '42000:[IBM][iSeries Access ODBC Driver]
Statement violates access rule: Connection is set to read only.'

The ODBC driver is setup with a connection type Read/Write (all SQL
statements allowed) and Naming convention set to SQL naming convention.

Thanks in advance

Keith

[DA Morgan]

Keith wrote:

I am trying to connect to a DB2 database using "iSeries Access ODBC
Driver" from Crystal Reports. I am able to report on tables and queries
but not stored procedures. I get the following error after I select the
procedure and enter the parameter.

Query Engine Error: '42000:[IBM][iSeries Access ODBC Driver]
Statement violates access rule: Connection is set to read only.'

The ODBC driver is setup with a connection type Read/Write (all SQL
statements allowed) and Naming convention set to SQL naming convention.

Thanks in advance

Keith

I am not sure if it still exists now that Crystal is owned by Business
Objects but the support section of the Crystal site used to contain this
information for all databases. You might want to look there.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[Keith]

While waiting for a response, I searched Crystal and found a solution
that instructed me to change the dsn regestry key AllowProcCalls = 1.
After completeing that, I now get Query Engine Error: 'Cannot obtain
error message from server.'

Any suggestions?

Keith