I'm trying to connect to a DB2 source via ODBC in crystal 8.5. ODBC tests out fine and I can query the database through DB2 command center and batch files using my userid and pwd. I can even login sucessfully to db2 on a pre-existing report and access the data.
Problem is, I cannot connect via ODBC to crystal or SQL designer to create a report from scratch or write a new query. I keep getting this error.
'ODBC Error [IBM][CLI Driver][DB2]SQL0551N UserID does not have permission to perform operation 'Select' on object SYSIBM.SYSTables. SQLState=42501
Obviously I have select permissions on the appropriate schema, but odbc is unhappy (from a system table point of view) when starting from scratch inside crystal or sql designer. Anyone encountered a similar issue. I'm at a loss as to whether this is db2 related or crystal.
Problem is, I cannot connect via ODBC to crystal or SQL designer to create a report from scratch or write a new query. I keep getting this error.
'ODBC Error [IBM][CLI Driver][DB2]SQL0551N UserID does not have permission to perform operation 'Select' on object SYSIBM.SYSTables. SQLState=42501
Obviously I have select permissions on the appropriate schema, but odbc is unhappy (from a system table point of view) when starting from scratch inside crystal or sql designer. Anyone encountered a similar issue. I'm at a loss as to whether this is db2 related or crystal.