Business Objects DeskI: DA0005 “No column or data to fetch”
This is just a quick tip to help people fix an odd error I encountered whilst runing a Freehand SQL query against a MySQL 5 database, I’d used prompted queries against MySQL previously so that wasn’t an issue – I’m speculating a little but in my case the data provider used subqueries and both the inner and outer query were prompted which is a little unusual.
The error I received was DA0005 “No column or data to fetch”…
C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\odbc
You’ll need to add the following in the relevant section, in my case I added it under Generic, Generic ODBC and MySQL 5.
After closing and restarting DeskI everything was fine, please bear in mind that if you’re running a client/server installation and your Inforview users need to run the report you’ll need to change the settings on the server too.