Hello.
I have often connected Crystal Reports to AS400 tables using the Client Access ODBC driver.
But now for the first time I am trying to access an AS400 Stored Procedure. And we keep getting errors (depending how we tweak the Driver settings).
The initial error being:
Database Connector Error:'4200:[IBM][iSeries Access ODBC Driver]Statement violates access rule: Connection is set to read only. [Database Vendor Code:30186]'
We tweaked the ODB driver and now the latest error being:
Database Connector Error:'42501:[IBM][iSeries Access ODBC Driver][DB2 UCB]SQL0601- TEST in KXMLIB type *FILE already exists. [Database Vendor Code:-601]'
TEST is the Stored Procedure name. I suspect its created a table that isn't being dropped when done?
Any insight on these errors, would be appreciated. Thanks!
Regards,
Mark H. Edwards
I have often connected Crystal Reports to AS400 tables using the Client Access ODBC driver.
But now for the first time I am trying to access an AS400 Stored Procedure. And we keep getting errors (depending how we tweak the Driver settings).
The initial error being:
Database Connector Error:'4200:[IBM][iSeries Access ODBC Driver]Statement violates access rule: Connection is set to read only. [Database Vendor Code:30186]'
We tweaked the ODB driver and now the latest error being:
Database Connector Error:'42501:[IBM][iSeries Access ODBC Driver][DB2 UCB]SQL0601- TEST in KXMLIB type *FILE already exists. [Database Vendor Code:-601]'
TEST is the Stored Procedure name. I suspect its created a table that isn't being dropped when done?
Any insight on these errors, would be appreciated. Thanks!
Regards,
Mark H. Edwards
