MySQL Bugs: #820: Crystal Reports doesnt like

Bug #820	Crystal Reports doesnt like
Submitted:	9 Jul 2003 13:02	Modified:	6 Oct 2003 2:44
Reporter:	Miguel Gonzalez	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.06	OS:	Windows (Windows XP)
Assigned to:	Bugs System	CPU Architecture:	Any

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