By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,386 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Connecting to Stored Procedure from Crystal

P: n/a
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

Aug 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Aug 15 '06 #2

P: n/a
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

Aug 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.