Bug #820 Crystal Reports doesnt like

Description:
When adding table with longtext to Crystal I get "Provider: Table does not exist".

How to repeat:
When I try to add a table with longtext fields to Crystal Reports using "Active Data / ADO" connetion with the MySQL.OLEDB provider the following error occurs resulting on the table not being added to the report.  "Provider: Table does not exist".  The following is the definition of the table that is causing the error.

CREATE TABLE `event` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `entry_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  `location` varchar(50) NOT NULL default '',
  `descr` longtext NOT NULL,
  `map_img` varchar(50) NOT NULL default '',
  `directions` longtext NOT NULL,
  `days_deny_register` int(11) NOT NULL default '0',
  `end_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

Hi !!

Looks like you are using MyOLEDB provider, and as this is not updated recently, it may not be supporting longtext mapping.

Try switching to Connector/ODBC 3.51.06 with Crystal, which should work perfectly.

Thanks
Venu