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:Microsoft Windows (Windows XP)
Assigned to: Bugs System CPU Architecture:Any

[9 Jul 2003 13:02] Miguel Gonzalez
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;
[17 Jul 2003 23:13] Venu Anuganti
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