First off, I created a new MySQL ODBC connection and everything connected successfully.
When I open a Crystal Report, I click on the refresh button and select that newly created datasource (that I created via the MySQL ODBC driver), enter in the user credentials associated with this datasource (and the user has all grants to all tables used in this report) BUT when the credentials go through and the refresh is actually taking place I get the following error:
Database Connector Error: '24000:[MySQL][ODBC 5.2(a) Driver][mysqld-5.5.49-0ubuntu0.14.04.1]Invalid Cursor State
And, then it says Database Connector Error: ''
It only happens on certain reports and not others.
Please help this is extremely frustrating. Thanks!!