Prev: Reducing Pages HIGHWATER mark
Next: Error SQLCODE "-811", SQLSTATE "21000"
From: Keith on 15 Aug 2006 09:28
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

From: DA Morgan on 15 Aug 2006 11:29
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
damorgan(a)x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
 | 
Pages: 1
Prev: Reducing Pages HIGHWATER mark
Next: Error SQLCODE "-811", SQLSTATE "21000"